BaeMinClone

Tables (7)

Untitled (User)

  • Key (userIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (userName) — VARCHAR(45) — NOT NULL
  • Field2 (userId) — VARCHAR(45) — NOT NULL
  • Field3 (userPw) — VARCHAR(100) — NOT NULL
  • Field4 (userPhone) — VARCHAR(30)
  • Field (userMail) — VARCHAR(45)
  • Field2 (status) — VARCHAR(10) — NOT NULL — normal, vip, vvip, vvvip, black, delete
  • Field3 (createdAt) — TIMESTAMP — NOT NULL
  • Field5 (updatedAt) — TIMESTAMP
  • Field (address1) — VARCHAR(100)
  • Field2 (address2) — VARCHAR(100)
  • Field3 (address3) — VARCHAR(100)
  • Field4 (address4) — VARCHAR(100)
  • Field5 (address5) — VARCHAR(100)

Untitled (Review)

  • Key (reviewIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (contents) — VARCHAR(500) — NOT NULL
  • Field2 (good) — INT
  • Field3 (bad) — INT
  • Field4 (star) — INT
  • Field5 (createdAt) — TIMESTAMP — NOT NULL
  • Field (updatedAt) — TIMESTAMP
  • Field2 (status) — VARCHAR(10) — NOT NULL — normal, hot
  • Key (restIdx) — BIGINT — Foreign key → Untitled4.Key — NOT NULL — AUTO_INCREMENT

Untitled (Like)

  • Key (likeIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field2 (updatedAt) — TIMESTAMP
  • Field3
  • Field4
  • Key (userIdx) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Key (restIdx) — BIGINT — Foreign key → Untitled4.Key — NOT NULL — AUTO_INCREMENT

Untitled3 (Menu)

  • Key (menuIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Key (restIdx) — BIGINT — Foreign key → Untitled4.Key — NOT NULL — AUTO_INCREMENT
  • Field (menuName) — VARCHAR(45) — NOT NULL
  • Field2 (menuInfo) — VARCHAR(100)
  • Field3 (menuPrice) — INT — NOT NULL
  • Field4 (detailInfo) — TEXT
  • Field5 (option1) — VARCHAR(45)
  • Field6 (option2) — VARCHAR(45)
  • Field (option3) — VARCHAR(45)
  • Field (option4) — VARCHAR(45)
  • Field2 (option5) — VARCHAR(45)
  • Field3 (status) — VARCHAR(10) — NOT NULL — Y : 주문가능, N : 품절
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field (updatedAt) — TIMESTAMP

Untitled4 (Restaurant)

  • Key (restIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Field (restName) — VARCHAR(45) — NOT NULL
  • Field2 (restOwner) — VARCHAR(45) — NOT NULL
  • Field3 (restPhone) — VARCHAR(45) — NOT NULL
  • Field4 (restLocation) — VARCHAR(100) — NOT NULL
  • Field5 (deliveryFee1) — INT — NOT NULL
  • Field6 (deliveryFee2) — INT
  • Field7 (deliveryFee3) — INT
  • Field8 (category) — VARCHAR(45)
  • Field (tag1) — VARCHAR(20) — '신규,' '인기' 와같은 테그
  • Field2 (tag2) — VARCHAR(20)
  • Field3 (tag3) — VARCHAR(20)
  • Field4 (image) — TEXT
  • Field5 (info) — VARCHAR(200)
  • Field (originInfo) — TEXT — NOT NULL
  • Field (createdAt) — TIMESTAMP — NOT NULL
  • Field2 (updatedAt) — TIMESTAMP

Untitled5 (Order)

  • Key (orderIdx) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
  • Key (userIdx) — BIGINT — Foreign key → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Field6 (finalPrice) — INT — NOT NULL
  • Field (discount) — INT
  • Field (restRequest) — VARCHAR(100)
  • Field2 (deliveryRequest) — VARCHAR(100)
  • Field7 (status) — VARCHAR(10) — NOT NULL — 'C' : complete, 'R' : ready, 'D' : delivery, 'F' : fail
  • Field8 (createdAt) — TIMESTAMP — NOT NULL
  • Field (updatedAt) — TIMESTAMP

Untitled6 (OrderMenu)

  • Key (orderMenuIdx) — BIGINT — Primary key — NOT NULL
  • Key (orderIdx) — BIGINT — Foreign key → Untitled5.Key — NOT NULL — AUTO_INCREMENT
  • Key (menuIdx) — BIGINT — Foreign key → Untitled3.Key — NOT NULL — AUTO_INCREMENT
  • Field (number) — INT
  • Field2 (options) — VARCHAR(250)
  • Field3 (createdAt) — TIMESTAMP — NOT NULL
  • Field4 (updatedAt) — TIMESTAMP