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