gifty
Tables (8)
Item (주문품목)
- order_id (Key) — varchar(20) — Foreign key → Order.order_id — NOT NULL
- item_no (Field) — int
- product_id (Key2) — varchar(10) — Foreign key → Product.product_code — NOT NULL
Order (주문)
- order_id (Key) — varchar(20) — Primary key — NOT NULL
- gender (Field) — varchar(3)
- price (Field2) — int
- tel (Field3) — varchar(15)
- address1 (Field4) — varchar(50)
- address2 (Field6) — varchar(50)
- link (Field5) — varchar(512)
- shipment_status (Field7) — varchar(3)
- order_date (Field8) — datetime
- user_id (Key2) — varchar(20) — Foreign key → User.user_id — NOT NULL
Preference (선호도)
- product_code (Key) — varchar(10) — Foreign key → Product.product_code — NOT NULL
- gender (Field) — varchar(3)
- age (Field2) — varchar(10)
- price (Field3) — varchar(20)
Product (상품)
- product_code (Key) — varchar(10) — Primary key — NOT NULL
- type (Field8) — varchar(10)
- brand (Field4) — varchar(50)
- thumbnail (Field2) — varchar(512)
- product_name (Field) — varchar(50)
- title (Field3) — varchar(20)
- sub_title (Field6) — varchar(50)
- retail_price (Field9) — int
- supply_price (Field10) — int
- margin (Field7) — int
- link (Field5) — varchar(512)
- exposure_count (Field12) — int
- love_count (Field13) — int
- order_cound (Field14) — int
- register_date (Field11) — timestamp
User (회원)
- user_id (Key) — varchar(20) — Primary key — NOT NULL
- pwd (Field) — varchar(20)
- name (Field2) — varchar(10)
- join_date (Field3) — datetime
- purchase_no (Field4) — int
- purchase_amount (Field5) — int
- comment (Field6) — varchar(300)
gift (Untitled2)
- id (Key) — varchar(20) — Primary key — NOT NULL
- name (Field) — varchar(10)
- tel (Field2) — varchar(15)
- gender (Field3) — varchar(20)
- age (Field4) — varchar(20)
- price (Field5) — varchar(20)
- user_id (Key2) — varchar(20) — Foreign key → User.user_id — NOT NULL
option (옵션)
- option_name (Field) — varchar(10)
- type (Field2) — varchar(10)
- acti vate (Field3) — boolean
product_image (Untitled)
- product_code (Key) — varchar(10) — Foreign key → Product.product_code — NOT NULL
- image (Field)