meetqueue

Tables (5)

attends (Untitled4)

  • schedule_id (스케쥴ID) — PK — Foreign key → schedules.schedule_id — NOT NULL
  • meters (위치와 멀어진 정도)
  • attended (출석일시)

groups (Untitled2)

  • group_id (그룹 ID) — PK — Primary key — NOT NULL
  • name (그룹 이름)

members (Untitled3)

  • user_id (UUID) — PK — Foreign key → users.user_id — NOT NULL
  • group_id (그룹 ID) — PK — Foreign key → groups.group_id — NOT NULL
  • is_admin (관리자 여부)

schedules (Untitled)

  • schedule_id (스케쥴ID) — PK — Primary key — NOT NULL
  • group_id (그룹 ID) — PK — Foreign key → groups.group_id — NOT NULL
  • name (스케쥴 이름)
  • location (스케줄 위치)
  • deadline (스케줄 시간)
  • coord_lat (스케줄 상세위치)
  • coord_lng (스케줄 상세위치2)
  • radius (스케줄 위치 범위)

users (사용자)

  • user_id (UUID) — PK — Primary key — NOT NULL
  • name (VARCHAR(50))
  • email (VARCHAR(100)) — UK
  • password (VARCHAR)