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)