Oneul_nail
Tables (10)
Cart
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Like_Post
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
- post_id — BIGINT — Foreign key → Post.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Like_Style
- id — BIGINT — Primary key — NOT NULL
- style1 — VARCHAR(45) — NOT NULL
- style2 — VARCHAR(45)
- style3 — VARCHAR(45)
- updated_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
Order
- id — BIGINT — Primary key — NOT NULL — 주문id
- paymentMethod — VARCHAR(255)
- totalPrice — int(11) — NOT NULL
- status — VARCHAR(255)
Post
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- img_url — BLOB — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- shop_id — BIGINT — Foreign key → Shop.id — NOT NULL
Product
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- img_url — BLOB — NOT NULL
- price — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Reservation
- id — BIGINT — Primary key — NOT NULL
- shop_id — BIGINT — Foreign key → Shop.id — NOT NULL
- date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Review
- id — BIGINT — Primary key — NOT NULL
- shop_id — BIGINT — Foreign key → Shop.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- contents — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- star_point — INT — NOT NULL
- img_url — BLOB
Shop
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- like_cnt — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- img_url — BLOB — NOT NULL
- price — INT — NOT NULL
- shop_info — VARCHAR(300) — NOT NULL
- longitude — DECIMAL(18, 10) — NOT NULL
- latitude — DECIMAL(18, 10) — NOT NULL
User
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL
- role — VARCHAR(45) — NOT NULL
- email — VARCHAR(45) — NOT NULL
- password — VARCHAR(2000) — NOT NULL
- phone_num — VARCHAR(11) — NOT NULL
- status — varchar(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- isDeleted — BOOLEAN — NOT NULL