--各種マスターテーブル
    CREATE TABLE pay_div_m (pay_div_cd VARCHAR(5) PRIMARY KEY, pay_div_nm VARCHAR(20));
    CREATE TABLE gender_m (gender_cd VARCHAR(2) PRIMARY KEY, gender_div_nm VARCHAR(10));
    CREATE TABLE credit_div_m (credit_div_cd VARCHAR(5) PRIMARY KEY, credit_div_nm VARCHAR(30));
    CREATE TABLE goods_div_m (goods_div_cd VARCHAR(5) PRIMARY KEY, goods_div_nm VARCHAR(30));
    CREATE TABLE tax_m (app_date DATE PRIMARY KEY, tax_rate INT);
    CREATE TABLE order_sts_m (sts_cd VARCHAR(6) PRIMARY KEY, sts VARCHAR(20));
    
    
--レコード
--支払い種別
    INSERT INTO pay_div_m VALUES ('PY001', 'クレジットカード');
    INSERT INTO pay_div_m VALUES ('PY002', '銀行振込');
    INSERT INTO pay_div_m VALUES ('PY003', 'コンビニ決済');
    INSERT INTO pay_div_m VALUES ('PY004', '代引');

--性別マスタ
    INSERT INTO gender_m VALUES ('J0', '男性');
    INSERT INTO gender_m VALUES ('J1', '女性');
    INSERT INTO gender_m VALUES ('J9', 'その他');
    
--クレジットカード分類
    INSERT INTO credit_div_m VALUES ('CD001', 'VISA');
    INSERT INTO credit_div_m VALUES ('CD002', 'JCB');
    INSERT INTO credit_div_m VALUES ('CD003', 'Master');
    INSERT INTO credit_div_m VALUES ('CD004', 'AMERICAN EXPRESS');

--商品分類マスタ
    INSERT INTO goods_div_m VALUES ('K0001', '日用品');
    INSERT INTO goods_div_m VALUES ('K0002', 'パソコン・オフィス用品');
    INSERT INTO goods_div_m VALUES ('K0003', 'スポーツ＆アウトドア');
    INSERT INTO goods_div_m VALUES ('K0004', 'カー用品');
    INSERT INTO goods_div_m VALUES ('K0005', '食料品');
    INSERT INTO goods_div_m VALUES ('K0006', '家電');
    INSERT INTO goods_div_m VALUES ('K0007', 'ファッション'); 
    INSERT INTO goods_div_m VALUES ('K0008', '娯楽');

--消費税マスタ
    INSERT INTO tax_m VALUES ('1989-04-01', 3);
    INSERT INTO tax_m VALUES ('1997-04-01', 5);
    INSERT INTO tax_m VALUES ('2014-04-01', 8);
    INSERT INTO tax_m VALUES ('2019-10-01', 10);

--注文ステータス
    INSERT INTO order_sts_m VALUES ('STS001', '受注済');
    INSERT INTO order_sts_m VALUES ('STS002', '入荷待');
    INSERT INTO order_sts_m VALUES ('STS003', '発送準備');
    INSERT INTO order_sts_m VALUES ('STS004', '配送中');
    INSERT INTO order_sts_m VALUES ('STS010', 'お客様受取済');
    INSERT INTO order_sts_m VALUES ('STS999', 'キャンセル');