Ditto
Tables (9)
m_ditto_noti
- m_noti_no — bigint(20) — Primary key — NOT NULL
- m_noti_cntt — tinytext — NOT NULL
- m_noti_i_dt — datetime(6) — NOT NULL
- m_noti_nm — varchar(50) — NOT NULL
- m_noti_title — varchar(100) — NOT NULL
- m_noti_u_dt — datetime(6)
member
- member_no — bigint(20) — Primary key — NOT NULL
- login_id — varchar(50) — NOT NULL
- login_pw — varchar(255) — NOT NULL
- member_dt — varchar(1) — NOT NULL
- member_email — varchar(100) — NOT NULL
- member_i_dt — datetime(6) — NOT NULL
- member_nm — varchar(50) — NOT NULL
- member_tel — varchar(20)
- member_u_dt — datetime(6)
- member_recent_dt — datetime(6)
- answer_content — tinytext
- answer_date — datetime(6)
- qna_cntt — tinytext — NOT NULL
- qna_i_dt — datetime(6) — NOT NULL
- qna_status — varchar(20) — NOT NULL
- qna_title — varchar(100) — NOT NULL
- s_qna_answer — varchar(200)
- ord_no — bigint(20)
s_ditto_cart
- cart_id — bigint(20) — Primary key — NOT NULL
- cart_cnt — int(11) — NOT NULL
- member_no — bigint(20) — Foreign key → member.member_no — NOT NULL
- prod_id — bigint(20) — Foreign key → s_ditto_prod.prod_id — NOT NULL
s_ditto_ctg
- cat_cd — varchar(50) — Primary key — NOT NULL
- cat_nm1 — varchar(50) — NOT NULL
- cat_nm2 — varchar(50) — NOT NULL
- cat_nm3 — varchar(50) — NOT NULL
- cat_nm4 — varchar(50) — NOT NULL
- i_dt — datetime(6) — NOT NULL
- idx — int(11) — NOT NULL
- u_dt — datetime(6) — NOT NULL
s_ditto_dlvy
- invoice_no — bigint(20) — Primary key — NOT NULL
- dlvery_id — varchar(50) — NOT NULL
- dlvy_add — int(11)
- dlvy_cost — int(11)
- dlvy_cost_re — int(11)
- dlvy_tp — varchar(20)
- expect_dt — datetime(6)
- expect_type — varchar(50)
- expect_yn — varchar(1) — NOT NULL
- ord_no — bigint(20) — Foreign key → s_ditto_order.ord_no — NOT NULL
s_ditto_order
- ord_no — bigint(20) — Primary key — NOT NULL
- expect_dt — datetime(6)
- expect_yn — varchar(1) — NOT NULL
- ord_i_dt — datetime(6) — NOT NULL
- ord_price — int(11) — NOT NULL
- ord_qty — int(11) — NOT NULL
- ord_status — varchar(20) — NOT NULL
- prod_nm — varchar(100) — NOT NULL
- member_no — bigint(20) — Foreign key → member.member_no — NOT NULL
- prod_id — bigint(20) — Foreign key → s_ditto_prod.prod_id — NOT NULL
s_ditto_prod
- prod_id — bigint(20) — Primary key — NOT NULL
- margin — decimal(5,2)
- origin_price — int(11) — NOT NULL
- prod_desc — tinytext
- prod_i_dt — datetime(6) — NOT NULL
- prod_nm — varchar(100) — NOT NULL
- prod_u_dt — datetime(6)
- real_cnt — int(11) — NOT NULL
- sale_price — int(11) — NOT NULL
- sale_status — varchar(20) — NOT NULL
- tax_tp — varchar(20)
- cat_cd — varchar(50) — NOT NULL
- category — varchar(255)
s_ditto_prod_img
- img_no — bigint(20) — Primary key — NOT NULL
- img_i_dt — datetime(6) — NOT NULL
- img_nm — varchar(255) — NOT NULL
- img_path — varchar(255) — NOT NULL
- img_u_dt — datetime(6)
- prod_id — bigint(20) — Foreign key → s_ditto_prod.prod_id — NOT NULL
s_ditto_qa
- s_ditto_qa — bigint(20) — Primary key — NOT NULL
- answer_content — tinytext
- answer_date — datetime(6)
- qna_cntt — tinytext — NOT NULL
- qna_i_dt — datetime(6) — NOT NULL
- qna_status — varchar(20) — NOT NULL
- qna_title — varchar(100) — NOT NULL
- s_qna_answer — varchar(200)
- member_no — bigint(20) — Foreign key → member.member_no — NOT NULL
- ord_no — bigint(20) — Foreign key → s_ditto_order.ord_no