shoppingmal

Tables (8)

boardreply (계시판 답글)

  • id (Key2) — int — Primary key — NOT NULL
  • brno (Key) — int — Foreign key → sellboard.bno — NOT NULL
  • reply_text (Field) — varchar(100)

order (주문)

  • order_num (Key) — Primary key — NOT NULL
  • user_idnum (Key2) — int — Foreign key → user.user_idnum — NOT NULL
  • useer_id (Key22) — char(10) — Foreign key → user.user_id — NOT NULL
  • product_id (Key3) — int — Foreign key → product.product_id — NOT NULL
  • order_datetime (Field)

product (상품)

  • product_id (Key) — int — Primary key — NOT NULL
  • product_name (Field2) — char(10)
  • price (Field3) — int
  • amount (Field4) — int
  • regdate (Field) — date
  • seller_idnum (Key2) — int — Foreign key → seller.seller_idnum — NOT NULL
  • seller_id (Key22) — char(10) — Foreign key → seller.seller_id — NOT NULL

reviewboard (리뷰계시판)

  • review_id (Key) — int — Primary key — NOT NULL
  • review_name (Field) — int
  • review_text (Field2) — varchar(200)
  • review_reg (Field3) — date
  • user_idnum (Key2) — int — Foreign key → user.user_idnum — NOT NULL
  • useer_id (Key22) — char(10) — Foreign key → user.user_id — NOT NULL

reviewreply (리뷰답글)

  • id (Key2) — int — Primary key — NOT NULL
  • reply text (Field) — varchar(100)
  • review_id (Key) — int — Foreign key → reviewboard.review_id — NOT NULL

sellboard (판매 계시판)

  • bno (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — int — Foreign key → product.product_id — NOT NULL
  • sellboard_name (Field) — char(10)
  • sellboard_text (Field2) — varchar(200)
  • sellboard_reg (Field3) — date

seller (판매자)

  • seller_idnum (Key) — int — Primary key — NOT NULL
  • seller_id (Key2) — char(10) — Primary key — NOT NULL
  • sell_password (Field2) — char(10)
  • seller_phonenumber (Field3) — char(10)
  • seller_regdate (Field4)

user (사용자)

  • user_idnum (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — char(10) — Primary key — NOT NULL
  • user_password (Field) — char(10)
  • user_phone (Field2) — varchar(30)
  • user_address (Field3)
  • user_regdate (Field4) — DATE