may
Tables (9)
MyPage
- user_id — NUMBER — Foreign key → user.user_id — NOT NULL
- sound_set — NUMBER
- mike_set — NUMBER
- profile — VARCHAR2(255)
S_chat
- chat_id — NUMBER — Primary key — NOT NULL
- smoll_id — NUMBER — Foreign key → smoll_game.smoll_id — NOT NULL
- room_id — NUMBER — Foreign key → smoll_game.room_id — NOT NULL
- user_id — NUMBER — Foreign key → smoll_game.user_id — NOT NULL
- message — CLOB
- is_muted — NUMBER(1)
- is_deafened — NUMBER(1)
b_chat
- chat_id — NUMBER — Primary key — NOT NULL
- big_id — NUMBER — Foreign key → big_game.big_id — NOT NULL
- room_id — NUMBER — Foreign key → big_game.room_id — NOT NULL
- user_id — NUMBER — Foreign key → big_game.user_id — NOT NULL
- message — CLOB
- is_muted — NUMBER(1)
- is_deafened — NUMBER(1)
big_game
- big_id — NUMBER — Primary key — NOT NULL
- room_id — NUMBER — Foreign key → room_user.room_id — NOT NULL
- user_id — NUMBER — Foreign key → room_user.user_id — NOT NULL
- life_card — VARCHAR2(255)
- value_card — VARCHAR2(255)
- play_time — TIMESTAMP
- debriefing — CLOB
board
- board_id — NUMBER — Primary key — NOT NULL
- user_id — NUMBER — Foreign key → user.user_id — NOT NULL
- title — VARCHAR2(400)
- details — CLOB
- upload — TIMESTAMP — NOT NULL
- like_count — NUMBER
room
- room_id — NUMBER — Primary key — NOT NULL
- room_name — VARCHAR2(200)
- max_user — NUMBER
- min_user — NUMBER
- password_n — NUMBER(1) — NOT NULL
- room_date — TIMESTAMP — NOT NULL
- game_mode — NUMBER — NOT NULL
room_user
- room_id — NUMBER — Foreign key → room.room_id — NOT NULL
- user_id — NUMBER — Foreign key → user.user_id — NOT NULL
smoll_game
- smoll_id — NUMBER — Primary key — NOT NULL
- room_id — NUMBER — Foreign key → room_user.room_id — NOT NULL
- user_id — NUMBER — Foreign key → room_user.user_id — NOT NULL
- play_time — TIMESTAMP — NOT NULL
- life_card — VARCHAR2(255)
- value_card — VARCHAR2(255)
- round — NUMBER
- score — NUMBER
- winner — VARCHAR2(200)
user
- user_id — NUMBER — Primary key — NOT NULL
- email — VARCHAR2(100)
- password — VARCHAR2(255)
- join_date — TIMESTAMP — NOT NULL
- nikName — VARCHAR2(100)