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