Manitto
Tables (5)
before_start_hidden_mission
- id — SERIAL
- roomid — INT
- mission_content — TEXT
message
- room_id — INT
- sender_id — INT
- content — TEXT
- time — TIMESTAMP
room
- id — SERIAL
- masterId — INT
- invite_code — VARCHAR(255)
- dynamic_link — VARCHAR(255)
- end_time — TIMESTAMP
- is_started — BOOLEAN
- common_mission — TEXT
user
- id — SERIAL — Primary key
- name — VARCHAR(255)
- pw — VARCHAR(255)
- token — VARCHAR(255)
user_room
- id — SERIAL — Primary key
- id (id2) — SERIAL — Foreign key → user.id
- userid — INT — NOT NULL
- roomid — INT — NOT NULL
- counterpart_name — VARCHAR(255) — NOT NULL
- profile_picture — VARCHAR(255)
- hidden_mission — TEXT