DB

Tables (5)

Friends_Info (Friends_info)

  • F.Key (user_num) — int — Foreign key → User_Info.P.Key — NOT NULL
  • Field (friends_list) — varchar(1000000)

Untitled (Room_info)

  • P.Key (room_num) — int — Primary key — NOT NULL
  • F.Key (room_master_user_num) — int — Foreign key → User_Info.P.Key — NOT NULL
  • Field (num_user) — int
  • Field (max_user) — int
  • Field (room_name) — varchar(50)
  • Field (private) — bool

Untitled (Login_Log)

  • P.Key (log_num) — int(sequence) — Primary key — NOT NULL
  • F.Key (user_num) — int — Foreign key → User_Info.P.Key — NOT NULL
  • Field (time) — timestamp
  • Field (result) — bool

User_Info (User_info)

  • P.Key (user_num) — int(sequence) — Primary key — NOT NULL
  • Field (user_name) — varchar(50)
  • Field (user_id) — varchar(50) — NOT NULL
  • Field (user_nickname) — varchar(50)
  • Field (user_pw) — varchar(50)
  • Field (user_state) — int
  • Field (current_room_num) — int
  • Field (birth) — date

sequence (Untitled)