樹木草花データベースの色彩マスタ，方角マスタ，季節マスタを入力する

前回の記事では樹木草花データベースのテーブル定義を行いました．今回は色彩マスタ，方角マスタ，季節マスタにデータを実際に入力します．

USE ExteriorDesign;

GO
INSERT INTO M_Colors VALUES ('青');

INSERT INTO M_Colors VALUES ('青紫');

INSERT INTO M_Colors VALUES ('赤');

INSERT INTO M_Colors VALUES ('赤紫');

INSERT INTO M_Colors VALUES ('薄紅');

INSERT INTO M_Colors VALUES ('薄紫');

INSERT INTO M_Colors VALUES ('褐色');

INSERT INTO M_Colors VALUES ('黄');

INSERT INTO M_Colors VALUES ('黒');

INSERT INTO M_Colors VALUES ('黒紫');

INSERT INTO M_Colors VALUES ('濃赤');

INSERT INTO M_Colors VALUES ('黄金');

INSERT INTO M_Colors VALUES ('白');

INSERT INTO M_Colors VALUES ('白紫');

INSERT INTO M_Colors VALUES ('橙');

INSERT INTO M_Colors VALUES ('淡黄');

INSERT INTO M_Colors VALUES ('淡紅');

INSERT INTO M_Colors VALUES ('淡紅白');

INSERT INTO M_Colors VALUES ('橙黄');

INSERT INTO M_Colors VALUES ('灰青');

INSERT INTO M_Colors VALUES ('ベージュ');

INSERT INTO M_Colors VALUES ('紅');

INSERT INTO M_Colors VALUES ('紅紫');

INSERT INTO M_Colors VALUES ('緑');

INSERT INTO M_Colors VALUES ('紫');

INSERT INTO M_Colors VALUES ('桃');

GO

INSERT INTO M_Direction VALUES ('北西');

INSERT INTO M_Direction VALUES ('南西');

INSERT INTO M_Direction VALUES ('南東');

INSERT INTO M_Direction VALUES ('北東');

INSERT INTO M_Direction VALUES ('西');

INSERT INTO M_Direction VALUES ('東');

INSERT INTO M_Direction VALUES ('南');

INSERT INTO M_Direction VALUES ('北');

GO

INSERT INTO M_SEASON VALUES ('立春', '春', '0204');

INSERT INTO M_SEASON VALUES ('雨水', '春', '0219');

INSERT INTO M_SEASON VALUES ('啓蟄', '春', '0306');

INSERT INTO M_SEASON VALUES ('春分', '春', '0321');

INSERT INTO M_SEASON VALUES ('清明', '春', '0405');

INSERT INTO M_SEASON VALUES ('穀雨', '春', '0420');

INSERT INTO M_SEASON VALUES ('立夏', '夏', '0506');

INSERT INTO M_SEASON VALUES ('小満', '夏', '0521');

INSERT INTO M_SEASON VALUES ('芒種', '夏', '0606');

INSERT INTO M_SEASON VALUES ('夏至', '夏', '0621');

INSERT INTO M_SEASON VALUES ('小暑', '夏', '0707');

INSERT INTO M_SEASON VALUES ('大暑', '夏', '0723');

INSERT INTO M_SEASON VALUES ('立秋', '秋', '0808');

INSERT INTO M_SEASON VALUES ('処暑', '秋', '0823');

INSERT INTO M_SEASON VALUES ('白露', '秋', '0908');

INSERT INTO M_SEASON VALUES ('秋分', '秋', '0923');

INSERT INTO M_SEASON VALUES ('寒露', '秋', '1008');

INSERT INTO M_SEASON VALUES ('霜降', '秋', '1023');

INSERT INTO M_SEASON VALUES ('立冬', '冬', '1107');

INSERT INTO M_SEASON VALUES ('小雪', '冬', '1122');

INSERT INTO M_SEASON VALUES ('大雪', '冬', '1207');

INSERT INTO M_SEASON VALUES ('冬至', '冬', '1222');

INSERT INTO M_SEASON VALUES ('小寒', '冬', '0105');

INSERT INTO M_SEASON VALUES ('大寒', '冬', '0120');