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