Flooding Server V2 - ClubForm ERD

Tables (7)

tb_club

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • leader_id — BIGINT — Foreign key → tb_user.id
  • image_url — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • description — VARCHAR(1000)
  • max_member — INT
  • approval_status — VARCHAR(20) — NOT NULL

tb_club_form

  • id — BIGINT
  • club_id — BIGINT — Foreign key → tb_club.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_club_form_answer

  • id — BIGINT
  • submission_id — BIGINT — Foreign key → tb_club_form_submission.id — NOT NULL
  • field_id — BIGINT — Foreign key → tb_club_form_field.id — NOT NULL
  • value — TEXT

tb_club_form_field

  • id — BIGINT
  • form_id — BIGINT — Foreign key → tb_club_form.id — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • description — TEXT
  • field_type — VARCHAR(50) — NOT NULL
  • field_order — INT — NOT NULL
  • is_required — BOOLEAN — NOT NULL

tb_club_form_field_option

  • id — BIGINT
  • field_id — BIGINT — Foreign key → tb_club_form_field.id — NOT NULL
  • label — VARCHAR(255) — NOT NULL
  • value — VARCHAR(255) — NOT NULL
  • option_order — INT — NOT NULL

tb_club_form_submission

  • id — BIGINT
  • form_id — BIGINT — Foreign key → tb_club_form.id — NOT NULL
  • user_id — BIGINT — Foreign key → tb_user.id — NOT NULL
  • submitted_at — TIMESTAMP — NOT NULL

tb_user

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • student_number — INT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • sex — VARCHAR(10) — NOT NULL
  • dormitory_room — INT — NOT NULL
  • specialty — VARCHAR(100)
  • penalty_score — INT — NOT NULL
  • cleaning_zone_id — BIGINT