Find My Price
Tables (4)
League
- id — bigint — Primary key — NOT NULL
- name — varchar(64)
- continent — varchar(64)
Player (player)
- id — bigint — Primary key — NOT NULL
- teamId (team_id) — bigint — Foreign key → Team.id — NOT NULL
- name — varchar
- backNumber (back_number) — integer
- height — integer
- weight — integer
- position — varchar(8)
Team (team)
- id — bigint — Primary key — NOT NULL
- name — varchar(8)
- homeGround (home_ground) — varchar(128)
- leage id (league_id) — bigint — Foreign key → League.id — NOT NULL
User (user)
- id — bigint — Primary key — NOT NULL — 자동생성되는 기본키
- email — varchar(128)
- name — varchar(8) — 사용자 이름
- password — varchar(64)
- nickname — varchar(10)
- role — varchar(12)
- createdAt (created_at) — timestamp
- lastUpdatedAt (last_updated_at) — timestamp