배달의 민족
테이블 (11)
Untitled (menu)
- Key (menuId) — INT — 기본 키 — NOT NULL
- Key (restaurantId) — INT — 외래 키 → restaurant.Key — NOT NULL
- Field (menuName) — INT
- Field2 (price) — INT
- Field (menuDescription) — VARCHAR(400)
- Field (menuOptions) — VARCHAR(50)
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (foodType)
- Key (foodTypeId) — INT — 기본 키 — NOT NULL
- Field (foodType) — INT
- Field2 (dateCreated) — TIMESTAMP
- Field3 (dateModified) — TIMESTAMP
Untitled (category)
- Key (categoryId) — INT — 기본 키 — NOT NULL
- Key (restaurantId) — INT — 외래 키 → restaurant.Key — NOT NULL
- Key (foodTypeId) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (orderDetail)
- Key (detailId) — INT — 기본 키 — NOT NULL
- Key (orderId) — INT — 외래 키 → order.Key — NOT NULL
- Key (menuId) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (addressList)
- Key (addressId) — INT — 기본 키 — NOT NULL
- customerId — INT — 외래 키 → customer.customerId — NOT NULL
- Field (cAddress) — INT
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (coupon)
- Key (couponId) — INT — 기본 키 — NOT NULL
- customerId — INT — 외래 키 → customer.customerId — NOT NULL
- Field (couponName) — VARCHAR(50)
- Field (discountAmount) — INT
- Field (periodOfUse) — DATE
- Field (minAmount) — INT
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (review)
- Key (reviewId) — INT — 기본 키 — NOT NULL
- Key (orderId) — INT — 외래 키 → order.Key — NOT NULL
- Field (rating) — INT
- Field (reviewImage) — VARCHAR(50)
- Field (reviewDescription) — VARCHAR(50)
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
Untitled (menuImage)
- Key (mImageId) — INT — 기본 키 — NOT NULL
- Key (menuId) — INT — 외래 키 → Untitled.Key — NOT NULL
- Field (menuImage) — TEXT
customer
- customerId — INT — 기본 키 — NOT NULL
- Field (nickname) — INT
- name (fName) — VARCHAR(100)
- contactNumber (lName) — INT
- address (contactDetail) — VARCHAR(400)
- Field4 (currentAddress) — VARCHAR(400)
- Field (grade) — VARCHAR(400)
- Field (emailAddress) — VARCHAR(400)
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
- Field (status) — VARCHAR(10)
order
- Key (orderId) — INT — 기본 키 — NOT NULL
- customerId — INT — 외래 키 → customer.customerId — NOT NULL
- Key (couponId) — INT — 외래 키 → Untitled.Key
- Field2 (customerRequest) — VARCHAR(50)
- Field3 (paymentMethod) — INT
- Field (giftBox) — VARCHAR(50)
- Field (orderStatus) — INT
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
restaurant
- Key (restaurantId) — INT — 기본 키 — NOT NULL
- Field (restName) — VARCHAR(100)
- Field2 (restDescrption) — VARCHAR(400)
- Field (restContact) — INT
- Field (restAddress) — VARCHAR(200)
- Field (restImage) — VARCHAR(50)
- Field (availability) — BOOL
- Field (dateCreated) — TIMESTAMP
- Field2 (dateModified) — TIMESTAMP
- Field (status) — VARCHAR(10)