playlink
Tables (6)
categories
- category_id — serial — Primary key — NOT NULL
- category_name — character — NOT NULL
chatting_logs
- chatting_log_id — serial — Primary key — NOT NULL
- room_id — integer — NOT NULL
- send_user_id — integer
- message — text — NOT NULL
- send_at — timestamp — NOT NULL
- is_system — boolean — NOT NULL
chatting_rooms
- room_id — serial — Primary key — NOT NULL
- title — text — NOT NULL
- created_at — timestamp — NOT NULL
locations
- location_id — serial — Primary key — NOT NULL
- user_id — integer — NOT NULL
match_likes
- like_id — bigint — Primary key — NOT NULL
- user_id — integer
- match_id — integer
- created_at — timestamp — NOT NULL
match_participants
- participant_id — serial — Primary key — NOT NULL
- match_id — integer — NOT NULL
- user_id — integer — NOT NULL
- join_status — integer — NOT NULL
- join_message — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- participant_level — integer
- participant_goals — integer
- image_url — character