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