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