Moyeoyo
Tables (8)
GROUPS
- groupId — VARCHAR(128) — Primary key
- hostUid — VARCHAR(128) — Foreign key → USERS.uid
- groupName — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- confirmedPlace_name — VARCHAR(255)
- confirmedPlace_lat — DECIMAL(10, 8)
- confirmedPlace_lng — DECIMAL(11, 8)
- confirmedTime — DATETIME
GROUP_MEMBERS
- memberUid — VARCHAR(128) — Primary key — NOT NULL
- groupId — VARCHAR(128) — Foreign key → GROUPS.groupId
INPUT_LOCATIONS
- groupId — VARCHAR(128) — Foreign key → GROUPS.groupId
- memberUid — VARCHAR(128) — Foreign key → GROUP_MEMBERS.memberUid — NOT NULL
- latLng_lat — DECIMAL(10, 8) — NOT NULL
- latLng_lng — DECIMAL(11, 8) — NOT NULL
- transportMode — VARCHAR(50)
PLACE_CANDIDATES
- placeCandidateId — INT — Primary key
- memberUid — VARCHAR(128) — Foreign key → INPUT_LOCATIONS.memberUid — NOT NULL
- placeId — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- latLng_lat — DECIMAL(10, 8)
- latLng_lng — DECIMAL(11, 8)
PLACE_VOTES
- placeCandidateId — INT — Foreign key → PLACE_CANDIDATES.placeCandidateId
- voterUid — VARCHAR(128) — Foreign key → GROUP_MEMBERS.memberUid — NOT NULL
- memberUid — VARCHAR(128) — Foreign key → PLACE_CANDIDATES.memberUid — NOT NULL
- votedAt — DATETIME
TIME_CANDIDATES
- timeCandidateId — INT — Primary key
- groupId — VARCHAR(128) — Foreign key → GROUPS.groupId
- time — DATETIME — NOT NULL
TIME_VOTES
- voterUid — VARCHAR(128) — Foreign key → GROUP_MEMBERS.memberUid — NOT NULL
- timeCandidateId — INT — Foreign key → TIME_CANDIDATES.timeCandidateId
- votedAt — DATETIME
USERS
- uid — VARCHAR(128) — Primary key
- nickname — VARCHAR(50) — NOT NULL
- profileImageUrl — VARCHAR(255)
- fcmToken — VARCHAR(255)
- defaultLocation_lat — DECIMAL(10, 8)
- defaultLocation_lng — DECIMAL(11, 8)
- defaultLocation_address — VARCHAR(255)