catchfood
Tables (9)
MealSession (MealPoll)
- Key (ID) — BIGINT — Primary key — NOT NULL
MealSessionInteraction (RecommendStore)
- Key (POLL_ID) — BIGINT — Foreign key → MealSession.Key — NOT NULL
- Key (STORE_ID) — BIGINT — Foreign key → Store.Key — NOT NULL
Party
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100)
PartyMember
- Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (PARTY_ID) — BIGINT — Foreign key → Party.Key — NOT NULL
Preference (PollPreference)
- Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (POLL_ID) — BIGINT — Foreign key → MealSession.Key — NOT NULL
- Field (CONTENT) — VARCHAR(200) — NOT NULL
Store
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(100) — NOT NULL
- Field2 (CATEGORY) — VARCHAR(30)
- Field (DISTANCE_IN_MINUTES_BY_WALK) — INT
- Field (BUSINESS_OPEN_HOUR) — TIME
- Field (BUSINESS_CLOSE_HOUR) — TIME
- Field (ADDRESS) — VARCHAR(200)
- Field2 (CONTACT) — VARCHAR(30)
- Field (RATING_STARS) — DECIMAL(2,1)
Untitled (Vote)
- Key (POLL_ID) — BIGINT — Foreign key → MealSessionInteraction.Key — NOT NULL
- Key (STORE_ID) — BIGINT — Foreign key → MealSessionInteraction.Key — NOT NULL
- Key (USER_ID) — BIGINT — Foreign key → User.Key — NOT NULL
Untitled (Menu)
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(50) — NOT NULL
- Field (PRICE) — INT
- Field (IMAGE_URL) — VARCHAR(2000)
User
- Key (ID) — BIGINT — Primary key — NOT NULL
- Field (NAME) — VARCHAR(20) — NOT NULL
- Field (PREF_LIKES) — VARCHAR(200)
- Field2 (PREF_DISLIKES) — VARCHAR(200)
- Field3 (PREF_ETC) — VARCHAR(200)