FitMate.
Tables (11)
bank_code
- id — INT — Primary key — NOT NULL
- code — VARCHAR(3) — NOT NULL
- Field
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_certification
- id — INT — Primary key — NOT NULL
- fit_record_id — INT — Foreign key → fit_record.id — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- fit_mate_user_id — INT — Foreign key → user.id — NOT NULL
- certification_status — ENUM(REQUESTED, CERTIFIED, REJECTED) — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_certification_vote
- id — INT — Primary key — NOT NULL
- fit_mate_user_id — INT — Foreign key → user.id — NOT NULL
- fit_certification_id — INT — Foreign key → fit_certification.id — NOT NULL
- vote — ENUM(AGREE, DISAGREE) — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_group
- id — INT — Primary key — NOT NULL
- fit_group_name — VARCHAR(30) — NOT NULL
- penalty_amount — INT — NOT NULL
- penalty_account_bank_code — INT — Foreign key → bank_code.id — NOT NULL
- penalty_account_number — VARCHAR(50) — NOT NULL
- category — INT — NOT NULL
- introduction — TEXT
- cycle — INT — NOT NULL
- frequency — INT — NOT NULL
- max_fit_mate — INT — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_group_history
- id — INT — Primary key — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- fit_group_name — VARCHAR(30) — NOT NULL
- penalty_amount — INT — NOT NULL
- penalty_account_bank_code — VARCHAR(3) — NOT NULL
- penalty_account_number — VARCHAR(50) — NOT NULL
- category — INT — NOT NULL
- introduction — TEXT
- cycle — INT — NOT NULL
- frequency — INT — NOT NULL
- max_fit_mate — INT — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_group_leader
- id — INT — Primary key — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- fit_leader_user_id — INT — Foreign key → user.id — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_mate
- id — INT — Primary key — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- fit_mate_user_id — INT — Foreign key → user.id — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_penalty
- id — INT — Primary key — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- fit_mate_user_id — INT — Foreign key → user.id — NOT NULL
- amount
- paid — ENUM(TRUE,FALSE) — NOT NULL
- penalty_done — ENUM(TRUE,FALSE) — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
fit_record
- id — INT — Primary key — NOT NULL
- certification_status — ENUM(REQUESTED, CERTIFIED, REJECTED) — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
- id (id2) — INT — Foreign key → user.id — NOT NULL
multy_media_end_point
- id — INT — Primary key — NOT NULL
- fit_group_id — INT — Foreign key → fit_group.id — NOT NULL
- end_point — TEXT — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)
user
- id — INT — Primary key — NOT NULL
- member_type — ENUM — NOT NULL
- oauth_token — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- state — ENUM(TRUE,FALSE) — NOT NULL
- created_at — DATE — NOT NULL
- created_by — VARCHAR(30) — NOT NULL
- updated_at — DATE
- updated_by — VARCHAR(30)