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