Codefolio
Tables (5)
achievements
- achivement_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- certificate_url — VARCHAR(500)
- achieved_at — DATE
- created_at — DATETIME
- updated_at — DATETIME
applications
- application_id — BIGINT — Primary key
- post_id — BIGINT — Foreign key → posts.post_id
- user_id — BIGINT — Foreign key → posts.user_id
- status — ENUM('pending','accepted','rejected')
- applied_at — DATETIME
posts
- post_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- target_role — ENUM('student','professor')
- created_at — DATETIME
- updated_at — DATETIME
projects
- project_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- repo_url — VARCHAR(500)
- start_date — DATE
- end_date — DATE
- created_at — DATETIME
- updated_at — DATETIME
users
- user_id — BIGINT — Primary key
- github_name — VARCHAR(255) — NOT NULL
- github_id — BIGINT — NOT NULL
- access_token_encrypted — TEXT
- scope — VARCHAR(255)
- last_synced_at — DATETIME
- role — ENUM('student','professor')
- email — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME