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