table schema

[l004ev2]

입고테이블

CREATE TABLE ebay_ipgo (
    in_date char(8) NOT NULL, 
    item char(100) NOT NULL, 
    qty integer NOT NULL DEFAULT 1, 
    price integer NOT NULL, 
    ship integer DEFAULT 0, 
    site_name char(60) NOT NULL, 
    bigo char(250) DEFAULT NULL, 
    gubun char(30) DEFAULT NULL, 
    sub_gubun char(30), 
    item_en char(150) DEFAULT NULL, 
    weight integer DEFAULT NULL, 
    four_zone integer DEFAULT NULL, 
    upc_code char(15) DEFAULT NULL, 
    use_gb integer DEFAULT 1, 
    val_date char(8) DEFAULT NULL, 
    bigo2 char(255) DEFAULT NULL, 
    ipchk char(1) DEFAULT '1', 
    sprice float DEFAULT NULL, 
    iseq integer NOT NULL, 
    i_name char(60) DEFAULT NULL,
    i_price numeric(5,2) DEFAULT NULL, 
    item_number char(12) DEFAULT NULL, 
    track_nm char(30) DEFAULT NULL, 
    r_tracknm char(30) DEFAULT NULL, 
    sale_com char(30) DEFAULT NULL, 
    sale_tel char(30) DEFAULT NULL , 
    PRIMARY KEY (in_date, item, iseq)) ;

판매테이블

CREATE TABLE ebay_sold (
    sale_date char(8) NOT NULL, 
    buyer char(50) NOT NULL, 
    item char(200) NOT NULL, 
    qty integer NOT NULL, 
    price float NOT NULL, 
    ship float NOT NULL, 
    country char(50) NOT NULL, 
    address char(250) NOT NULL, 
    tel char(30) NOT NULL, 
    bigo char(250) DEFAULT NULL, 
    ship_date char(8) DEFAULT NULL, 
    weight integer DEFAULT NULL, 
    shipping_service char(30) DEFAULT NULL, 
    rtn char(1) DEFAULT 'N', 
    ship_price integer DEFAULT NULL, 
    in_date char(10) DEFAULT NULL, 
    recieve_date char(10) DEFAULT NULL, 
    bigo2 char(30) DEFAULT NULL, 
    bigo3 char(30) DEFAULT NULL, 
    in_price integer DEFAULT NULL, 
    in_ship integer DEFAULT NULL, 
    use_yn char(10) DEFAULT NULL, 
    yoil char(10) DEFAULT NULL, 
    val_date char(8) DEFAULT NULL, 
    state char(30) DEFAULT NULL, 
    email char(50) DEFAULT NULL, 
    user_id char(30) DEFAULT NULL, 
    zip char(30) DEFAULT NULL, 
    tid numeric(5,0) NOT NULL, 
    iseq numeric(5,0) DEFAULT NULL, 
    add1 char(255) DEFAULT NULL, 
    add2 char(255) DEFAULT NULL, 
    b_city char(60) DEFAULT NULL, 
    p_trnid char(60) DEFAULT NULL, 
    cn char(2) DEFAULT NULL, 
    t_seq char(13) NOT NULL, 
    ship_ser char(1) DEFAULT NULL, 
    tracking_nm char(13) DEFAULT NULL, 
    prt_yn char(1) DEFAULT NULL, 
    p_plus decimal(5,2) DEFAULT 0, 
    p_min decimal(5,2) DEFAULT 0 , 
    PRIMARY KEY (sale_date, tid, t_seq)) ;

기초코드 테이블

CREATE TABLE ebay_code (
    reftp char(2) NOT NULL, 
    refcd char(6) NOT NULL, 
    refsnm char(60) NOT NULL, 
    refnm char(60) NOT NULL, 
    length integer DEFAULT NULL, 
    useyn char(1) DEFAULT NULL, 
    inuser char(8) DEFAULT NULL, 
    intime char(14) DEFAULT NULL, 
    upduser char(8) DEFAULT NULL, 
    updtime char(14) DEFAULT NULL, 
    bigo char(16) DEFAULT NULL, 
    sgubn char(3) DEFAULT NULL, 
    dgubn char(3) DEFAULT NULL, 
    scol integer DEFAULT NULL, 
    etc1 char(255) DEFAULT NULL, 
    etc2 char(30) DEFAULT NULL , 
    PRIMARY KEY (reftp, refcd, refsnm, refnm)) ;