jampot

Tables (17)

CalendarEvent (Untitled12)

  • room_id (Key) — Foreign key → EnsembleRoom.room_id — NOT NULL
  • player_id (Key2) — Foreign key → Player.player_id — NOT NULL
  • date (Field)

ChatRoom (Untitled13)

  • chat_room_id (Key) — Primary key — NOT NULL

ChatRoom_Player (Untitled17)

  • ChatRoom_Player_id (Key3) — Primary key — NOT NULL
  • player_id (Key) — Foreign key → Player.player_id — NOT NULL
  • chat_room_id (Key2) — Foreign key → ChatRoom.chat_room_id — NOT NULL

EnsembleRoom (Untitled8)

  • room_id (Key) — Primary key — NOT NULL
  • room_name (Field)
  • player_enter_pw (Field2)
  • audience_enter_pw (Field3)

EnsembleRoom_Genre (Untitled11)

  • room_id (Key) — Foreign key → EnsembleRoom.room_id — NOT NULL
  • genre_id (Key2) — Foreign key → Genre.genre_id — NOT NULL

EnsembleRoom_Level (Untitled9)

  • Level_id (Key) — Foreign key → Level.Level_id — NOT NULL
  • room_id (Key2) — Foreign key → EnsembleRoom.room_id — NOT NULL

EnsembleRoom_Like (Untitled16)

  • room_like_id (Key3) — Primary key — NOT NULL
  • player_id (Key) — Foreign key → Player.player_id — NOT NULL
  • room_id (Key2) — Foreign key → EnsembleRoom.room_id — NOT NULL

EnsembleRoom_Session (Untitled10)

  • room_id (Key2) — Foreign key → EnsembleRoom.room_id — NOT NULL
  • Session_id (Key) — Foreign key → Session.Session_id — NOT NULL
  • Max (Field)
  • current_player_num (Field2)

Genre (Untitled2)

  • genre_id (Key) — Primary key — NOT NULL
  • genre_name (Field)

Level (Untitled6)

  • Level_id (Key) — Primary key — NOT NULL
  • Level_name (Field)

Player (Untitled3)

  • player_id (Key) — Primary key — NOT NULL
  • nickname (Field)
  • self_introduction (Field2)
  • profile_img_url (Field3)
  • audio_file_url (Field4)
  • email (Field5)
  • provider (Field6)
  • calender_service_agreement (Field8)
  • provider_id (Field7)
  • public (Field10)

Player_Level (Untitled7)

  • level_id (Key) — Foreign key → Level.Level_id — NOT NULL
  • player_id (Key2) — Foreign key → Player.player_id — NOT NULL

Player_Like (Untitled15)

  • player_like_id (Key2) — Primary key — NOT NULL
  • liking_id (Key) — Foreign key → Player.player_id — NOT NULL
  • liked_id (Key3) — Foreign key → Player.player_id — NOT NULL

Player_Session (Untitled5)

  • Session_id (Key) — Foreign key → Session.Session_id — NOT NULL
  • player_id (Key2) — Foreign key → Player.player_id — NOT NULL

Session (Untitled4)

  • Session_id (Key) — Primary key — NOT NULL
  • Session_name (Field)

chatMessage (Untitled14)

  • chat_id (Key) — Primary key — NOT NULL
  • chat_room_id (Key2) — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • sender_id (Key3) — Foreign key → Player.player_id — NOT NULL
  • timestamp (Field)
  • message (Field3)

player_genre (Untitled)

  • genre_id (Key3) — Foreign key → Genre.genre_id — NOT NULL
  • player_id (Key) — Foreign key → Player.player_id — NOT NULL