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