certificate

Tables (11)

categories

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

certificates

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • category_id — BIGINT — NOT NULL
  • overview — TEXT
  • official_site — VARCHAR(255)
  • organization — VARCHAR(100)
  • exam_method — TEXT
  • passing_criteria — TEXT
  • qualification — TEXT
  • fee — VARCHAR(100)
  • prospects — TEXT
  • features — TEXT

favorites

  • user_id — BIGINT — Primary key — NOT NULL
  • certificate_id — BIGINT — Primary key — NOT NULL

phases

  • id — BIGINT
  • name — VARCHAR(20) — NOT NULL

schedule_types

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL

schedules

  • id — BIGINT
  • certificate_id — BIGINT — NOT NULL
  • round — INTEGER
  • phase_id — BIGINT — NOT NULL
  • type_id — BIGINT — NOT NULL
  • start_date — DATE
  • end_date — DATE

share_comment

  • id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT

share_post

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT
  • category_id — BIGINT

study_comment

  • id — BIGINT
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT

study_post

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT
  • category_id — BIGINT

users

  • id — BIGINT
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • profile_image — VARCHAR(255)
  • created_at — DATETIME
  • password_reset_token — VARCHAR(255)
  • password_reset_expiry — DATETIME