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)