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

TERMS

  • TERMS — VARCHAR2(4000)

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)