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