배달의 민족

테이블 (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)