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