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)