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