--注文
    CREATE TABLE order_t (
        order_no INT PRIMARY KEY,
        order_date DATE,
        user_id VARCHAR(10),
        sts_cd VARCHAR(10),
        pay_div_cd VARCHAR(10),
        deli_exp_date DATE,
        deli_date DATE,
        deli_company VARCHAR(20),
        tracing_no VARCHAR(20),
        arrive_exp_date DATE,
        deli_comm INT,
        postage INT,
        tax_rate INT
    );
    
    CREATE TABLE order_detail_t (
        order_no INT,
        goods_id VARCHAR(10),
        goods_unit_price INT,
        goods_num INT,
    PRIMARY KEY (order_no, goods_id)
    );
    
--レコード
    INSERT INTO order_t VALUES
        (1,'2014-11-20','CU00000003','ST010','PY002',
        '2014-11-20','2014-11-20','ヤマト','xxxxxxxxxx',
        '2014-11-21',0,1836,20850),
        (2,'2014-11-25','CU00000001','ST010','PY001',
        '2014-11-25','2014-11-25','ヤマト','xxxxxxxxxx',
        '2014-11-26',0,1836,94520),
        (3,'2014-11-30','CU00000005','ST010','PY001',
        '2014-12-02','2014-12-02','ヤマト','xxxxxxxxxx',
        '2014-12-03',0,1836,108562),
        (4,'2014-12-02','CU00000004','ST010','PY004',
        '2014-12-02','2014-12-02','ヤマト','xxxxxxxxxx',
        '2014-12-03',510,1836,103310);
        
    INSERT INTO order_detail_t VALUES
        (1,'ITM0000002',12915,100),
        (1,'ITM0000005',10952,80),
        (1,'ITM0000003',24500,1),
        (1,'ITM0000004',3712,5),
        (1,'ITM0000001',79110,5),
        (2,'ITM0000001',79110,1),
        (2,'ITM0000002',12915,50),
        (2,'ITM0000004',3712,5),
        (2,'ITM0000005',10952,40),
        (3,'ITM0000001',79110,3),
        (3,'ITM0000003',24500,1),
        (3,'ITM0000005',10952,100),
        (4,'ITM0000001',79110,2),
        (4,'ITM0000002',12915,60),
        (4,'ITM0000004',3712,8),
        (4,'ITM0000005',10952,30);