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