Team Join
Tables (8)
Category
- category_id — INT — Primary key
- name — VARCHAR(50) — NOT NULL
Class
- class_id — INT — Primary key
- host_id — INT — Foreign key → User.user_id
- category_id — INT — Foreign key → Category.category_id
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- max_participants — INT
- created_at — DATETIME
Location
- location_id — INT — Primary key
- class_id — INT — Foreign key → Class.class_id
- host_id — INT — Foreign key → Class.host_id
- category_id — INT — Foreign key → Class.category_id
- region_name — VARCHAR(100) — NOT NULL
Participation
- user_id — INT — Foreign key → User.user_id
- class_id — INT — Foreign key → Class.class_id
- category_id — INT — Foreign key → Class.category_id
- joined_at — DATETIME
Review
- review_id — INT — Primary key
- class_id (class_id2) — INT — Foreign key → Class.class_id
- user_id (user_id2) — INT — Foreign key → User.user_id
- rating — INT
- comment — TEXT — EX
- reviewed_at — DATETIME
Tag
- tag_id — INT — Primary key
- name — VARCHAR(50) — NOT NULL
User
- user_id — INT — Primary key
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- age — INT
- gender — ENUM('M', 'F', 'Other')
- registered_at — DATETIME
UserTag
- user_id — INT — Foreign key → User.user_id
- tag_id — INT — Foreign key → Tag.tag_id