bda

Tables (9)

Club (Untitled)

  • club_id (Key) — int — Primary key — NOT NULL
  • stadium_id (Key2) — int — Foreign key → Stadium.stadium_id — NOT NULL
  • club_name (Field) — varchar(50)
  • director (Field2) — varchar(50)
  • game (Field3) — int
  • win_game (Field4) — int

Game (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • stadium_id (Key2) — int — Foreign key → Stadium.stadium_id — NOT NULL
  • schedule (Field4) — datetime
  • club1 (Key3) — int — Foreign key → Club.club_id — NOT NULL
  • club2 (Key4) — int — Foreign key → Club.club_id — NOT NULL
  • winner (Key5) — int — Foreign key → Club.club_id — NOT NULL

Personal Info (Untitled8)

  • user_id (Key) — varchar(50) — Primary key — NOT NULL
  • password (Field) — varchar(50)
  • name (Field2) — varchar(20)

Player (Untitled4)

  • id (Key3) — int — Primary key — NOT NULL
  • club_id (Key2) — int — Foreign key → Club.club_id — NOT NULL
  • name (Field) — varchar(50)
  • birth (Field2) — date
  • debut (Field3) — int
  • nationality (Field4) — varchar(30)
  • position (Field5) — varchar(20)
  • uniform_number (Field6) — int
  • is_captain (Field7) — int

Public transport (Untitled5)

  • name (Key) — varchar(50) — Primary key — NOT NULL
  • stadium_id (Key2) — int — Foreign key → Stadium.stadium_id — NOT NULL
  • vehicle (Field) — int
  • distance_stadium (Field3) — int
  • bus_number (Field4) — varchar(20)
  • station_number (Field5) — varchar(20)

Restaurant (Untitled6)

  • name (Key) — varchar(50) — Primary key — NOT NULL
  • stadium (Key2) — int — Foreign key → Stadium.stadium_id — NOT NULL
  • main_dish (Field) — varchar(50)
  • distance_stadium (Field3) — int

Review (Untitled7)

  • review_id (Key3) — int — Primary key — NOT NULL
  • user_id (Key) — varchar(50) — Foreign key → Personal Info.user_id — NOT NULL
  • stadium_id (Key2) — int — Foreign key → Stadium.stadium_id — NOT NULL
  • date (Field) — date
  • content (Field2) — varchar(100)
  • star_num (Field3) — float
  • user_nickName (Field4) — varchar(50)

Stadium (Untitled9)

  • stadium_id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • hometowm (Field2) — varchar(50)

Staff (Untitled2)

  • name (Key) — varchar(50) — Primary key — NOT NULL
  • club_id (Key2) — int — Foreign key → Club.club_id — NOT NULL
  • profession (Field2) — varchar(20)