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)