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)