Badminton

Tables (13)

Authority (authority)

  • Authority Id (authority_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(10)
  • Method (method) — VARCHAR(10)
  • Target (target) — VARCHAR(10)
  • Ddescription (description) — VARCHAR(1000)

Badminton Skill (badminton_skill)

  • Badminton Skill Id (badminton_skill_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(10)

Club (club)

  • Club Id (club_id) — INT — Primary key — NOT NULL
  • Name (name) — VARCHAR(10)
  • Description (descriptions) — VARCHAR(1000)

Club Location (club location)

  • Club Id (club_id) — INT — Foreign key → Club.Club Id — NOT NULL
  • Location Id (location_id) — INT — Foreign key → Location.Location Id — NOT NULL

Location (location)

  • Location Id (location_id) — INT — Primary key — NOT NULL
  • Address (address) — VARCHAR(100

Meeting (meeting)

  • Meeting Id (meeting_id) — INT — Primary key — NOT NULL
  • Club Id (club_id) — INT — Foreign key → Club.Club Id — NOT NULL
  • Date (date) — DATE
  • Location (locationl) — VARCHAR(100)
  • Discription (discription) — VARCHAR(1000)
  • Capacity (capacity) — INT
  • Location Id (location_id) — INT — Foreign key → Location.Location Id — NOT NULL

Meeting User (meeting_user)

  • Meeting Id (meeting_id) — INT — Foreign key → Meeting.Meeting Id — NOT NULL
  • User Id (user_idk) — VARCHAR(50) — Foreign key → User.User Id — NOT NULL
  • Join Date (join_date) — DATE

Member Level (member_level)

  • Member Level Id (member_level_id) — INT — Primary key — NOT NULL
  • Club Id (club_id) — INT — Foreign key → Club.Club Id — NOT NULL
  • Name (name) — VARCHAR(10)

Member Level Authority (member_level_authority)

  • Member Level Authority Id (member_level_authority_id) — INT — Primary key — NOT NULL
  • Member Level Id (member_level_id) — INT — Foreign key → Member Level.Member Level Id — NOT NULL
  • Authority Id (authority_id) — INT — Foreign key → Authority.Authority Id — NOT NULL

Post (post)

  • Post Id (post_id) — INT — Primary key — NOT NULL
  • Writer Id (writer_id) — INT — Foreign key → User.User Id — NOT NULL
  • Club Id (club_id) — INT — Foreign key → Club.Club Id — NOT NULL
  • Post State Id (post_state_id) — INT — Foreign key → Post State.Post State Id — NOT NULL

Post State (post_state)

  • Post State Id (post_state_id) — INT — Primary key — NOT NULL
  • State (state) — VARCHAR(10)

User (user)

  • User Id (user_idk) — VARCHAR(50) — Primary key — NOT NULL
  • Name (name) — VARCHAR(10)
  • Email (email) — VARCHAR(50)
  • Badminton Skill Id (badminton_skill_id) — INT — Foreign key → Badminton Skill.Badminton Skill Id — NOT NULL
  • Date of Join (date_of_join) — DATE
  • Username (username) — VARCHAR(10)

User Club (user_club)

  • Club Id (club_id) — INT — Foreign key → Club.Club Id — NOT NULL
  • User Id (user_idk) — INT — Foreign key → User.User Id — NOT NULL
  • Date of Join (join_date) — DATE — NOT NULL
  • Withdraw Date (withdraw_date) — DATE
  • Member Level Id (member_level_id) — INT — Foreign key → Member Level.Member Level Id — NOT NULL