ERD

Tables (7)

AUTHORITY (권한)

  • authority_name (Key) — varchar(30) — Primary key — NOT NULL

GAME (게임 정보)

  • game_id (Key) — int — Primary key — NOT NULL
  • game_year (Field) — int
  • game_month (Field2) — int
  • game_day (Field3) — int
  • game_time (Field4) — int
  • game_video (Field5) — string
  • game_xy (Field6) — string
  • gameScore (Field7) — varchar(255)

USER (사용자 계정)

  • user_id (PK) — int — Primary key — NOT NULL
  • user_email (Unique) — String
  • user_password (Field2) — String

USERGAME (사용자 게임 정보)

  • usergame_id (Key) — int — Primary key — NOT NULL
  • user_id (PK) — Int — Foreign key → USER.user_id — NOT NULL
  • game_id (Key2) — Int — Foreign key → GAME.game_id — NOT NULL
  • user_distance (Field12) — float
  • user_attack (Field11) — int
  • user_physical (Field9) — int
  • user_defence (Field10) — int
  • user_speed (Field8) — int
  • user_stamina (Field7) — int
  • user_goal (Field3) — int
  • user_save (Field4) — int
  • user_max_speed (Field) — float
  • user_heart (Field5) — float
  • user_position (Field14) — varchar(30)
  • user_heatmap (Field6) — varchar(255)
  • user_sprint (Field2) — int
  • user_pass (Field13) — float

USERINFO (사용자정보)

  • id (PK) — int — Primary key — NOT NULL
  • user_id (PK2) — int — Foreign key → USER.user_id — NOT NULL
  • user_profile_image (Field) — varchar(255)
  • user_name (Field2) — varchar(30)
  • user_age (Field3) — int
  • user_position (Field4) — varchar(30)
  • user_height (Field5) — float
  • user_weight (Field6) — float
  • user_physical (Field7) — int

USER_AUTHORITY (유저 권한)

  • authority_name (Key) — varchar(30) — Foreign key → AUTHORITY.authority_name — NOT NULL
  • user_id (PK) — int — Foreign key → USER.user_id — NOT NULL

Untitled