COMHUTER

Tables (5)

MEMBER_TABLE

  • ID — VARCHAR2(25 BYTE) — Primary key
  • PASSWORD — VARCHAR2(255 BYTE)
  • NAME — VARCHAR2(10 BYTE)
  • EMAIL — VARCHAR2(50 BYTE)
  • PHONE — VARCHAR2(11 BYTE)
  • ZIPCODE — VARCHAR2(5 BYTE)
  • ADDRESS — VARCHAR2(50 BYTE)
  • ADDRESS2 — VARCHAR2(50 BYTE)
  • BIRTHDAY — VARCHAR2(8 BYTE)
  • INDATE — DATE

cart

  • user_id (ID) — VARCHAR2(25 BYTE) — Foreign key → MEMBER_TABLE.ID
  • goods_id (id2) — NUMBER — Foreign key → goods.id
  • quantity — NUMBER — NOT NULL

category

  • ca_id — NUMBER — Primary key
  • ca_ref — NUMBER
  • ca_name — VARCHAR2(50) — NOT NULL

goods

  • id — NUMBER — Primary key
  • ca_id (ca_id2) — NUMBER — Foreign key → category.ca_id
  • name — VARCHAR2(500) — NOT NULL
  • price — NUMBER — NOT NULL
  • quantity — NUMBER — NOT NULL
  • content — VARCHAR2(4000)
  • regist_date — DATE

total_order

  • order_id — NUMBER(20) — Primary key — NOT NULL
  • user_id (ID) — VARCHAR2(25 BYTE) — Foreign key → MEMBER_TABLE.ID
  • order_date — DATE — NOT NULL
  • user_name — VARCHAR2(20) — NOT NULL
  • delivery_request — VARCHAR2(50)
  • phone_num — VARCHAR2(20) — NOT NULL
  • member_add1 — NUMBER(15) — NOT NULL
  • member_add2 — VARCHAR2(100) — NOT NULL
  • member_add3 — VARCHAR2(50) — NOT NULL
  • payment_card — VARCHAR2(20) — NOT NULL
  • total_amount — NUMBER(20) — NOT NULL
  • Processing — VARCHAR2(35) — NOT NULL