Web-Shopping-DB

Tables (14)

answer

  • answer_id — bigint — Primary key
  • created_date — datetime
  • last_modified_date — datetime
  • comment — longtext — ongtext nul
  • qna_status — varchar(255)

cart

  • cart_id — bigint — Primary key
  • cart_item_id — bigint — Foreign key → cart_item.cart_item_id
  • user_id — bigint — Foreign key → users.user_id
  • answer_id — bigint — Foreign key → users.answer_id
  • created_date — datetime
  • last_modified_date — datetime

cart_item

  • cart_item_id — bigint — Primary key
  • item_count — int

image

  • image_id — bigint — Primary key
  • category — varchar(31) — NOT NULL
  • created_date — datetime
  • last_modified_date — datetime
  • ext — varchar(255)
  • hash — varchar(255)
  • image_order — int — NOT NULL
  • image_path — varchar(255)
  • is_representative — bit — NOT NULL
  • original_name — varchar(255)
  • thumbnail_path — varchar(255)
  • upload_name — varchar(255)
  • item_id — bigint
  • notice_id — bigint
  • review_id — bigint

item

  • item_id — bigint — Primary key
  • default_option_id — bigint — Foreign key → item_option.item_option_id
  • cart_item_id — bigint — Foreign key → item_option.cart_item_id
  • picked_id — bigint — Foreign key → picked_item.picked_id
  • user_id — bigint — Foreign key → picked_item.user_id
  • created_date — datetime
  • last_modified_date — datetime
  • category — varchar(255)
  • delivery_price — int — NOT NULL
  • description — longtext
  • discount_rate — int
  • item_name — varchar(255) — NOT NULL
  • item_price — int — NOT NULL
  • item_status — varchar(255)
  • sales_quantity — int — NOT NULL
  • view_count — bigint — NOT NULL

item_option

  • item_option_id — bigint — Primary key
  • item_id — bigint — Foreign key → item.item_id
  • cart_item_id — bigint — Foreign key → cart_item.cart_item_id
  • picked_id — bigint — Foreign key → item.picked_id
  • user_id — bigint — Foreign key → item.user_id
  • additional_price — int
  • default_option — bit — NOT NULL
  • item_count — int
  • option_detail — varchar(255)
  • option_name — varchar(255)

notice

  • notice_id — bigint — Primary key
  • user_id — bigint — Foreign key → users.user_id
  • answer_id — bigint — Foreign key → users.answer_id
  • created_date — datetime
  • last_modified_date — datetime
  • content — longtext
  • notice_category — varchar(255)
  • title — varchar(255)
  • view_count — bigint — NOT NULL

ordered_item

  • order_item_id — bigint — Primary key
  • created_date — datetime
  • last_modified_date — datetime
  • discount_rate — int — NOT NULL
  • discounted_price — int — NOT NULL
  • item_count — int — NOT NULL
  • item_details — varchar(255)
  • option_details — varchar(255)
  • price — int — NOT NULL
  • item_item_id — bigint
  • item_option_id — bigint
  • order_id — bigint

orders

  • order_id — bigint — Primary key
  • shipping_info_id — bigint — Foreign key → shipping_info.shipping_info_id
  • user_id (user_id2) — bigint — Foreign key → shipping_info.user_id
  • answer_id — bigint — Foreign key → shipping_info.answer_id
  • created_date — datetime
  • last_modified_date — datetime
  • address_detail — varchar(255)
  • address_simple — varchar(255)
  • phone — varchar(255)
  • zip_code — varchar(255)
  • delivery_company — varchar(255)
  • delivery_date — date
  • delivery_price — int — NOT NULL
  • message — varchar(255)
  • order_number — varchar(255)
  • orders_status — varchar(255)
  • recipient — varchar(255)
  • tracking_number — varchar(255)
  • user_id — bigint

picked_item

  • picked_id — bigint — Primary key
  • user_id — bigint — Foreign key → users.user_id

question

  • question_id — bigint — Primary key
  • created_date — datetime
  • last_modified_date — datetime
  • comment — longtext — ongtext nul
  • qna_status — varchar(255)
  • answer_id — bigint
  • item_id — bigint
  • user_id — bigint

review

  • review_id — bigint — Primary key — NOT NULL
  • created_date — datetime
  • last_modified_date — datetime
  • best — bit — NOT NULL
  • comment — varchar(255) — archar(255) nul
  • rating — int
  • item_id — bigint
  • user_id — bigint

shipping_info

  • shipping_info_id — bigint — Primary key
  • user_id (user_id2) — bigint — Foreign key → users.user_id
  • answer_id — bigint — Foreign key → users.answer_id
  • address_detail — varchar(255)
  • address_simple — varchar(255)
  • phone — varchar(255)
  • zip_code — varchar(255)
  • recipient — varchar(255)

users

  • user_id — bigint — Primary key
  • answer_id — bigint — Foreign key → answer.answer_id
  • created_date — datetime
  • last_modified_date — datetime
  • email — varchar(255)
  • grade — varchar(255)
  • last_connected_date — datetime
  • nick_name — varchar(255)
  • password — varchar(255)
  • phone — varchar(255)
  • profile_image — varchar(255)
  • provider_id — varchar(255)
  • user_name — varchar(255)
  • user_role — varchar(255)
  • user_status — varchar(255)