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