ㅇㅇ
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