ㅇㅇ

Tables (11)

category

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50) — NOT NULL
  • parent_id — int

discount

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • rate — int
  • price — int

image

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • image_url — varchar(255) — NOT NULL
  • caption — varchar(50)

inquiry

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • uploaddate — datetime — NOT NULL
  • content — varchar(255) — NOT NULL

inventory

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • stock — int — NOT NULL

order

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • total_price — int — NOT NULL
  • date — datetime — NOT NULL
  • req — varchar(100)
  • name — varchar(255) — NOT NULL
  • address — varchar(255) — NOT NULL
  • address2 — varchar(255) — NOT NULL
  • phone_number — varchar(255) — NOT NULL
  • product_name — varchar(255) — NOT NULL
  • product_img — varchar(255) — NOT NULL
  • product_count — int — NOT NULL

order_detail

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • order_id — bigint — NOT NULL
  • price — int — NOT NULL
  • count — int — NOT NULL
  • order_state — varchar(255) — NOT NULL
  • refund_check — varchar(1) — NOT NULL

order_refund

  • id — bigint — Primary key — NOT NULL
  • order_detail_id — bigint — NOT NULL
  • refund_reason — varchar(255) — NOT NULL

product

  • id — bigint — Primary key — NOT NULL
  • category_id — bigint — NOT NULL
  • name — varchar(50) — NOT NULL
  • status — varchar(50) — NOT NULL
  • price — int — NOT NULL
  • deliverycharge — int — NOT NULL
  • content — text
  • uploaddate — datetime — NOT NULL
  • sales — int
  • hits — int

review

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — NOT NULL
  • rating — int — NOT NULL
  • uploaddate — datetime — NOT NULL
  • content — varchar(255) — NOT NULL
  • likes — int
  • image_url — varchar(255)

user

  • id — bigint — Primary key — NOT NULL
  • seq — varchar(255) — NOT NULL
  • pw — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • phone — int — NOT NULL
  • email — vachar(50) — NOT NULL
  • birth — date — NOT NULL
  • address — varchar(50)
  • address2 — varchar(30)
  • admin_check — boolean — NOT NULL