erd_cloud
Tables (12)
badge_list (Untitled11)
- user_sequence (Key2) — INT — Foreign key → users.user_sequence — NOT NULL
- badge_sequence (Key) — INT — Foreign key → badges.badge_sequence — NOT NULL
badges (Untitled5)
- badge_sequence (Key) — INT — Primary key — NOT NULL
- badge_image_path (Field) — VARCHAR(20)
board (Untitled12)
- notice_sequence (Key) — INT — Primary key — NOT NULL
- user_sequence (Key2) — INT — Foreign key → users.user_sequence — NOT NULL
- title (Field) — VARCHAR(10)
- contents (Field2) — VARCHAR(50)
- register_time (Field3) — DATE
- modify_time (Field4) — DATE
- heart (Field6) — INT
- div (Field7) — INT
comments (Untitled2)
- comment_sequence (Key) — INT — Primary key — NOT NULL
- article_sequence (Key2) — INT — Foreign key → board.notice_sequence — NOT NULL
- contents (Field) — VARCHAR(50)
- good_count (Field2) — INT
- nickname (Field4) — VARCHAR(50)
- private (Field3) — INT
- register_time (Field5) — TIMESTAMP
friend_accept_list (단방향에주의)
- send_sequence (Key) — NOT NULL
- get_sequence (Field)
friend_list (양방향에 주의)
- user_sequence (Key) — INT — Foreign key → users.user_sequence — NOT NULL
- friend_id (Field) — INT
game_logs (게임 기록)
- game_sequence (game_id) — INT — Primary key — NOT NULL
- user_sequence (Key) — INT — Foreign key → users.user_sequence — NOT NULL
- clear_time — INT
- clear_floor — INT
- cumulative_damage — VARCAHR(20)
- heart (Field) — INT
report_board (Untitled6)
- report_sequence (Key) — INT — Primary key — NOT NULL
- user_sequence (Key2) — INT — Foreign key → users.user_sequence — NOT NULL
- report_kind (Field) — INT
- report_reason (Field2) — VARCHAR(50)
- get_user_id (Field4) — INT
- register_time (Field3) — DATE
- modify_time (Field5) — DATE
rooms (Untitled4)
- room_no (Key) — INT — Primary key — NOT NULL
- room_title (Field) — VARCHAR(20)
- open_div (Field2) — VARCHAR(2)
- room_pwd (Field3) — VARCHAR(20)
timelines (Untitled8)
- timeline_log (Key) — VARCHAR(50) — Primary key — NOT NULL
- user_sequence (Key2) — INT — Foreign key → users.user_sequence — NOT NULL
user_exercise_log (Untitled7)
- user_exercise_no (Key) — INT — Primary key — NOT NULL
- user_sequence (Key2) — INT — Foreign key → users.user_sequence — NOT NULL
- exercise_date (Field) — DATE
- count (Field3) — INT
- div (Field5) — INT
users (Untitled10)
- user_sequence (Key) — INT — Primary key — NOT NULL
- email (Field3) — VARCHAR(30)
- exp (Field16) — INT
- gender (Field2) — VARCHAR(2)
- imagePath (Field) — VARCHAR(15)
- level (Field5) — INT
- manner_point (Field8) — DCIMAL
- min_clear_time (Field9) — TIME
- total_play_time (Field10) — TIME
- rank (Field11) — INT
- profile_image (Field12) — VARCHAR(255)
- nickname (Field4) — VARCHAR(255)