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)