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)