about_cat_erd
Tables (5)
goods_image_tbl
- goods_image_id — number(10) — Primary key — NOT NULL
- goods_id — number(10) — Foreign key → goods_tbl.goods_id — NOT NULL
- Field — varchar2(50)
- Field2 — varchar2(50)
- Field3 — varchar2(50)
- Field4 — date — sysdate
goods_tbl
- goods_id — number(10) — Primary key — NOT NULL
- goods_type — varchar2(50) — enum으로
- goods_name — varchar2(100)
- goods_brand — varchar2(100)
- goods_price — number(10)
- goods_sell_price — number(10) — 할인율
- goods_stock — number(10)
- delivery_charge — number(10) — 없앨까?
- goods_description — varchar2(3000)
member_tbl
- member_id — varchar2(100) — Primary key — NOT NULL
- member_pw — varchar2(100)
- member_name — varchar2(30)
- member_gender — varchar2(10)
- phone — varchar2(12) — -제외하고
- sms_valid_check — number(1) — 동의는
- member_email1 — varchar2(50) — 메일
- member_email2 — varchar2(30) — 메일
- email_valid_check — number(1) — 동의는
- postcode — varchar2(10) — 구
- address1_new — varchar2(100)
- address1_old — varchar2(100)
- address2 — varchar2(100)
- birth_year — number(5)
- birth_month — number(2)
- birth_day — number(2)
- birth_day_yinyang — enum(yin,yang) — 솔직히
- member_add_date — date — sysdate
- member_deleted — number(1) — 탈퇴했으면
order_tbl
- order_seq_num — number(20) — Primary key — NOT NULL — 차례차례
- order_id — number(20) — NOT NULL — 고유
- goods_id — number(10) — Foreign key → goods_tbl.goods_id — NOT NULL
- goods_title — varcahr2(100)
- goods_sale_price — number(6)
- goods_fileName — varchar(60)
- order_goods_qty — number(5)
- delivery_state — varchar2(20)
- 주문자아이디 (member_id) — varchar2(100) — Foreign key → member_tbl.member_id — NOT NULL
- orderer_hp — varchar2(50)
- receiver_name — varchar2(50)
- reseiver_hp — varchar2(50)
- delivery_address — varchar2(500)
- delivery_msg — varchar2(500)
- pay_method — varchar2(200)
- paycard_com_name — varchar2(50)
- pay_hp_num — varchar2(20)
- pay_month_installment — number(3)
- pay_order_time — date — sysdate
shopping_cart_tbl
- member_id (member_id2) — varchar2(100) — Foreign key → member_tbl.member_id — NOT NULL
- goods_id (goods_id2) — number(10) — Foreign key → goods_tbl.goods_id — NOT NULL
- cart_id — number(10)
- cart_goods_qty — number(4)
- credate — date — sysdate