product
Tables (13)
card
- id — BIGINT — Primary key — NOT NULL
- create_at — DATETIME(6)
- modified_at — DATETIME(6)
- card_status — VARCHAR(255)
- money — INT — NOT NULL
- name — VARCHAR(255)
- member_id — BIGINT
- INDEX — `FKbf204t9qecurpbyoqlmpcy5t4`
- id (id2) — BIGINT — Foreign key → member.id — NOT NULL
coupon
- id — BIGINT — Primary key — NOT NULL
- coupon_status — VARCHAR(255)
- discount — INT — NOT NULL
- expiry_date — DATETIME(6)
- name — VARCHAR(255)
- start_date — DATETIME(6)
delivery
- id — BIGINT — Primary key — NOT NULL
- address_detail — VARCHAR(255)
- city — VARCHAR(255)
- complete_time — DATETIME(6)
- delivery_status — VARCHAR(255)
- dong — VARCHAR(255)
- gu — VARCHAR(255)
- take_over_time — DATETIME(6)
- driver_id — BIGINT
- order_id — BIGINT
- create_at — DATETIME(6)
- modified_at — DATETIME(6)
- INDEX — `FKgts2r2etfncl0q1l1cvee3x29`
- INDEX — `FKu4e8rjwmg09vmas3ccjwglso`
driver
- id — BIGINT — Primary key — NOT NULL
- create_at — DATETIME(6)
- modified_at — DATETIME(6)
- driver_status — VARCHAR(255)
- name — VARCHAR(255)
- phone — VARCHAR(255)
- address_city — VARCHAR(255)
- address_dong — VARCHAR(255)
- address_gu — VARCHAR(255)
member
- id — BIGINT — Primary key — NOT NULL
- address_city — VARCHAR(255)
- address_detail — VARCHAR(255)
- address_dong — VARCHAR(255)
- address_gu — VARCHAR(255)
- email — VARCHAR(255)
- image — VARCHAR(255)
- member_status — VARCHAR(255)
- name — VARCHAR(255)
- password — VARCHAR(255)
- point — INT — NOT NULL
- receive_point — INT — NOT NULL
- used_point — INT — NOT NULL
member_coupon
- id — BIGINT — Primary key — NOT NULL
- discount — INT — NOT NULL
- name — VARCHAR(255)
- member_id — BIGINT
- INDEX — `FKf8n3lu0dfwmhvcikamg220lgg`
orders
- id — BIGINT — Primary key — NOT NULL
- admin_memo — VARCHAR(255)
- approve_date_time — DATETIME(6)
- approve_status — VARCHAR(255)
- order_status — VARCHAR(255)
- pay_type — VARCHAR(255)
- payment_date_time — DATETIME(6)
- purchaser — BIGINT
- purchaser_memo — VARCHAR(255)
- total_price — INT — NOT NULL
- use_point — INT — NOT NULL
- member_id — BIGINT
- store_id — BIGINT
- INDEX — `FKpktxwhj3x9m4gth5ff6bkqgeb`
- INDEX — `FK5n14sr4mswfdtaoiwj7rkt0mw`
product
- id — BIGINT — Primary key — NOT NULL
- category — VARCHAR(255)
- name — VARCHAR(255)
- price — INT — NOT NULL
- product_status — VARCHAR(255)
- seller — BIGINT
- order_id — BIGINT
- shopping_basket_id — BIGINT
- INDEX — `FK18j7hot76crqfb6x6xn7mlxt6`
- INDEX — `FK7xi5txw5kyegbro2ingrl0l6`
product_image
- id — BIGINT — Primary key — NOT NULL
- image — VARCHAR(255)
- product_id — BIGINT
- INDEX — `FK6oo0cvcdtb6qmwsga468uuukk`
- id (id2) — BIGINT — Foreign key → product.id — NOT NULL
review
- review_id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255)
- likes — INT — NOT NULL
- title — VARCHAR(255)
- store_id — BIGINT
review_comment
- review_comment_id — BIGINT — Primary key — NOT NULL
- content — VARCHAR(255)
- likes — INT — NOT NULL
- member_id — VARCHAR(255)
- review_id — BIGINT
- INDEX — `FK9j7pkcpuestrwjre1a1902biu`
shopping_basket
- id — BIGINT — Primary key — NOT NULL
- total_price — INT — NOT NULL
- member_id — BIGINT
- INDEX — `FKlpfw83xrtbtx7dgm5yapidg9w`
- id (id2) — BIGINT — Foreign key → member.id — NOT NULL
store
- store_id — BIGINT — Primary key — NOT NULL
- city — VARCHAR(255)
- detail — VARCHAR(255)
- dong — VARCHAR(255)
- gu — VARCHAR(255)
- store_status — VARCHAR(255)
- name — VARCHAR(255)
- phone — VARCHAR(255)