Project
Tables (15)
INVENTORY
- INVENTORYID — NUMBER — Primary key
- p_id — NUMBER — Foreign key → PRODUCT.p_id
- userid — VARCHAR2(24) — Foreign key → Member.userid
- img_id — NUMBER — Foreign key → PRODUCT.img_id
- p_amount — NUMBER
MENU
- category_no — NUMBER — Primary key — NOT NULL
- category_name — VARCHAR2(255)
- m_depth — NUMBER
- category_no (parent_no) — NUMBER — Foreign key → MENU.category_no — NOT NULL
Member
- userid — VARCHAR2(24) — Primary key
- pay_method — NUMBER — Foreign key → payment_method.pay_method — NOT NULL
- passwd — VARCHAR2(60)
- birth — DATE
- email — VARCHAR2(40)
- address1 — VARCHAR2(100)
- address2 — VARCHAR2(200)
- tel — VARCHAR2(16)
- mileage — NUMBER
- regdate — DATE
- joindate — DATE
- managerkey — CHAR(1) — NOT NULL
- username — VARCHAR2(255)
PRODUCT
- p_id — NUMBER — Primary key
- category_no — NUMBER — Foreign key → MENU.category_no — NOT NULL
- img_id — NUMBER — Foreign key → img.img_id
- p_stock — NUMBER
- p_price — DATE
- p_img — VARCHAR2(2550)
- p_name — NUMBER
- p_desc — VARCHAR2(4000)
- p_star — NUMBER
- p_tag — VARCHAR2(2550)
PRODUCT_DETAIL
- d_id — NUMBER — Primary key
- p_id — NUMBER — Foreign key → PRODUCT.p_id
- img_id — NUMBER — Foreign key → PRODUCT.img_id
- d_subject — VARCHAR2(255)
- d_content — VARCHAR2(4000)
- d_thumb — VARCHAR2(255)
- d_tag — VARCHAR2(2550)
PRODUCT_OPTIONS
- p_id — NUMBER — Foreign key → PRODUCT.p_id
- img_id — NUMBER — Foreign key → PRODUCT.img_id
- p_color — VARCHAR2(2550)
- o_price — NUMBER
- o_description — VARCHAR2(765)
QNA
- qna_id — NUMBER — Primary key — NOT NULL
- userid — VARCHAR2(24) — Foreign key → Member.userid
- d_id — NUMBER — Foreign key → PRODUCT_DETAIL.d_id
- p_id — NUMBER — Foreign key → PRODUCT_DETAIL.p_id
- img_id — NUMBER — Foreign key → PRODUCT_DETAIL.img_id
- qna_depth — NUMBER
- qna_content — NUMBER
- qna_subject — VARCHAR2(500)
- qna_hidden — char(1)
- qna_date — date
- qna_id (qna_id2) — NUMBER — Foreign key → QNA.qna_id — NOT NULL
- userid (userid2) — VARCHAR2(24) — Foreign key → QNA.userid
- qna_status — char(1)
REVIEWS
- d_id — NUMBER — Foreign key → PRODUCT_DETAIL.d_id
- p_id — NUMBER — Foreign key → PRODUCT_DETAIL.p_id
- userid — VARCHAR2(24) — Foreign key → Member.userid
- img_id — NUMBER — Foreign key → PRODUCT_DETAIL.img_id
- r_star — NUMBER
- r_content — VARCHAR2(4000)
- r_date — NUMBER
- r_depth — NUMBER
category (CopyOfMENU)
- category_no — NUMBER — Primary key — NOT NULL
- category_name — VARCHAR2(255)
- depth (m_depth) — NUMBER
- category_no (parent_no) — NUMBER — Foreign key → MENU.category_no — NOT NULL
coupon_list
- coupon_listid — NUMBER — Primary key — NOT NULL
- couponid — NUMBER — Foreign key → event.couponid — NOT NULL
- userid — VARCHAR2(24) — Foreign key → Member.userid
- p_id — NUMBER — Foreign key → event.p_id
event
- couponid — NUMBER — Primary key — NOT NULL
- p_id — NUMBER — Foreign key → PRODUCT.p_id
- sale — NUMBER
img
- img_id — NUMBER — Primary key
- img_path — VARCHAR2(255)
- img_name — VARCHAR2(255)
- size_w — NUMBER
- size_h — NUMBER
pay_ORDER
- ORDERID — NUMBER — Primary key
- p_id — NUMBER — Foreign key → PRODUCT.p_id
- userid — VARCHAR2(24) — Foreign key → Member.userid
- category_no — NUMBER — Foreign key → PRODUCT.category_no — NOT NULL
- o_ORDERDATE — DATE
- o_SHIPADDR — VARCHAR2(2550)
- o_PRICE — NUMBER
- o_SHIPTYPE — VARCHAR2(255)
- o_STATE — NUMBER
- o_CHECKSUM — VARCHAR2(255)
- o_ORDERCOUNT — NUMBER
payment_method
- pay_method — NUMBER — Primary key — NOT NULL
- card_company — CHAR(2)