ㅂㅈ

Tables (8)

address

  • addr_key (Key) — NUMBER — Primary key — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • zipcode — VARCHAR2(300) — NOT NULL
  • addr — VARCHAR2(300) — NOT NULL
  • addrDetail — VARCHAR2(300) — NOT NULL
  • req — VARCHAR2(300)

admin (Untitled)

  • admin_id — NUMBER — Primary key — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • adminName — VARCHAR2(150)
  • adminpw — VARCHAR2(150)
  • auth — NUMBER

cart

  • cart_id (Key) — NUMBER — Primary key — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • quantity — NUMBER

category

  • category_key — NUMBER — Primary key — NOT NULL
  • category_name — VARCHAR2(100)

order (Untitled2)

  • order_key — NUMBER — Primary key — NOT NULL
  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • price — NUMBER
  • orderDate — DATE
  • zipcode — VARCHAR2(300)
  • addr — VARCHAR2(300)

product

  • product_id — NUMBER — Primary key — NOT NULL
  • category_key — NUMBER — Foreign key → category.category_key — NOT NULL
  • product_name — VARCHAR2(200) — NOT NULL
  • description — VARCHAR2(300)
  • thumb — VARCHAR2(200)
  • review — NUMBER

review

  • user_id — NUMBER — Foreign key → users.user_id — NOT NULL
  • admin_id — NUMBER — Foreign key → admin.admin_id — NOT NULL
  • product_id — NUMBER — Foreign key → product.product_id — NOT NULL
  • star — NUMBER
  • detailReview — VARCHAR2(300)
  • simpleReview — VARCHAR2(200)
  • photo — VARCHAR2(200)

users

  • user_id — NUMBER — Primary key — NOT NULL
  • usertype — VARCHAR2(10)
  • username — VARCHAR2(150) — NOT NULL
  • password — VARCHAR2(150) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • phone — VARCHAR2(100) — NOT NULL