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