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