coupangEats

Tables (8)

HOME

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → shortRestanrantInfo.id — NOT NULL
  • 아이디2 — BIGINT — Foreign key → shortRestanrantInfo.아이디2 — NOT NULL
  • address — VARCHAR(45)
  • createAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • alarmCount — BIGINT
  • findMenu — VARCHAR(45)
  • menuType — VARCHAR(45)
  • deliverTag — VARCHAR(45)
  • shortRestaurant — BIGINT — NOT NULL

Order

  • 아이디 — BIGINT — Primary key — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • quantity — BIGINT
  • 아이디2 — BIGINT — NOT NULL
  • 아이디3 — BIGINT — NOT NULL

OrderHistory

  • 아이디 — BIGINT — Primary key — NOT NULL
  • 아이디 (아이디3) — BIGINT — Foreign key → User.아이디 — NOT NULL
  • reOrder — VARCHAR(45)
  • review — VARCHAR(45)
  • receipt — VARCHAR(45)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • 아이디2 — BIGINT — NOT NULL

User

  • 아이디 — BIGINT — Primary key — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • name — VARCHAR(45)
  • password — VARCHAR(200)
  • email — VARCHAR(50)
  • phoneNumber — VARCHAR(20)

favorite

  • id — BIGINT — Primary key — NOT NULL
  • 아이디 — BIGINT — Foreign key → User.아이디 — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • restaurantNum — INT
  • restaurantImage — TEXT — NOT NULL
  • foodType — VARCHAR(45)
  • deleteRestaurant — BIGINT
  • shortRestaurant — BIGINT — NOT NULL

restaurantInfo

  • 아이디2 — BIGINT — Foreign key → Order.아이디 — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • menuName — VARCHAR(45)
  • menuFee — INT
  • description — VARCHAR(200)

search

  • id — BIGINT — Primary key — NOT NULL
  • id (id2) — BIGINT — Foreign key → shortRestanrantInfo.id — NOT NULL
  • 아이디2 — BIGINT — Foreign key → shortRestanrantInfo.아이디2 — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • foodImage — TEXT
  • foodType — VARCHAR(45)
  • deliverTag — VARCHAR(45)
  • shortRestaurant — BIGINT — NOT NULL

shortRestanrantInfo

  • id — BIGINT — Primary key — NOT NULL
  • 아이디2 — BIGINT — Foreign key → restaurantInfo.아이디2 — NOT NULL
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • status — VARCHAR(45)
  • menuImage — TEXT
  • restaurantName — VARCHAR(45)
  • deliverTakenTime — INT
  • rating — DECIMAL
  • distance — DECIMAL
  • isPackable — VARCHAR(45)
  • orderFee — INT