--顧客マスタ

    CREATE TABLE user_m (
        user_id VARCHAR(10) PRIMARY KEY,
        user_f_nm VARCHAR(20),
        user_f_nm_kn VARCHAR(20),
        user_nm VARCHAR(20),
        user_nm_kn VARCHAR(20),
        user_birth DATE,
        gender_cd VARCHAR(2),
        mail_address VARCHAR(100),
        user_post_no VARCHAR(10),
        user_prefecture_nm VARCHAR(20),
        user_municipality_nm VARCHAR(50),
        user_city_nm VARCHAR(50),
        user_address VARCHAR(100),
        user_building_nm VARCHAR(100),
        user_tel_no VARCHAR(20),
        user_passwd VARCHAR(20)
    );

    CREATE TABLE credit_card_t (
        user_id VARCHAR(10),
        credit_div_cd VARCHAR(5),
        credit_no VARCHAR(30),
        credit_nm VARCHAR(50),
        validated_month VARCHAR(2),
        validated_year INT,
        sc_cd VARCHAR(5),
        PRIMARY KEY (user_id, credit_no)
    );

    CREATE TABLE login_hist_t (
        user_id VARCHAR(10),
        sfx INT,
        login_datetime DATETIME,
        conn_ip VARCHAR(20),
        term_info VARCHAR(20),
        PRIMARY KEY (user_id, sfx)
    );
    

--レコード
--顧客マスタ
    INSERT INTO user_m VALUES (
        'CU00000001','山田','ヤマダ','一','ハジメ',
        '1973-06-06','J0','h.yamada@hoge.com',
        '140-0014','東京都','品川区','大井',
        '○○-○','マンション1399','090-xxxx-xxxx','hX8UEE3'
    );

    INSERT INTO user_m VALUES (
        'CU00000002','高橋','タカハシ','龍也','タツヤ',
        '1970-11-10','J0','t.takahashi@hoge.com',
        '230-0063','神奈川県','横浜市鶴見区','鶴見',
        '×ー××','', '090-xxxx-xxxx','UQ0A6B3R'
    );

    INSERT INTO user_m VALUES (
        'CU00000003','黒枝','マエダ','准','ジュン',
        '1975-01-03','J0','j.maeda@hoge.com',
        '333-0823','埼玉県','川口市','石神',
        '○○-○','','090-yyyy-1234','DUHwNLLk'
    );

    INSERT INTO user_m VALUES (
        'CU00000004','二宅','ミヤケ','章介','ショウスケ',
        '1970-10-10','J0','s.miyake@hoge.com',
        '273-0031','千葉県','船橋市','西船',
        '○○-○','アパート101','090-yyyy-5678','F2QG7Nzw'
    );

    INSERT INTO user_m VALUES (
        'CU00000005','涼元','スズモト','悠一','ユウイチ',
        '1969-01-13','J0','y.suzumoto@hoge.com',
        '321-0207','栃木県','下都賀郡壬生町','北小林',
        '××××','','090-1234-xxxx','DZy5qadL'
    );
    
--クレジットカード
    INSERT INTO credit_card_t VALUES (
        'CU00000001',
        'CD001',
        'xxxx-xxxx-xxxx-xxxx',
        'HAJIME YAMADA',
        '03',
        2017,
        'xxx'
    );

    INSERT INTO credit_card_t VALUES (
        'CU00000005',
        'CD001',
        'xxxx-xxxx-xxxx-xxxx',
        'YUICHI SUZUMOTO',
        '03',
        2016,
        'xxx'
    );
    
--ログイン情報
    INSERT INTO login_hist_t VALUES (
        'CU00000001',1,
        '2014-10-01 10:00:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000001',2,
        '2014-10-10 12:27:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000001',3,
        '2014-10-25 20:30:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000001',4,
        '2014-11-03 10:15:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000001',5,
        '2014-11-05 15:06:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000001',6,
        '2014-12-01 16:56:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000002',1,
        '2014-05-05 15:30:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000002',2,
        '2014-07-07 12:30:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000002',3,
        '2014-11-25 09:30:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000003',1,
        '2013-12-24 11:11:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000003',2,
        '2014-01-10 12:20:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000003',3,
        '2014-10-10 15:27:00',
        'xxx.xxx.xxx.xxx',
        'PC'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000004',1,
        '2014-07-10 00:00:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );

    INSERT INTO login_hist_t VALUES (
        'CU00000005',1,
        '2014-07-05 19:42:00',
        'xxx.xxx.xxx.xxx',
        'スマートフォン'
    );