ProjectHub
Tables (6)
Badge
- id — BIGINT
- user_id — BIGINT — NOT NULL
- badge_name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
Comment
- id — BIGINT
- user_id — BIGINT — NOT NULL
- project_id — BIGINT — NOT NULL
- parent_comment_id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CommentLike
- id — BIGINT
- user_id — BIGINT — NOT NULL
- comment_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — comment_id)
Project
- id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- topic — VARCHAR(100) — NOT NULL
- github_link — VARCHAR(255) — NOT NULL
- description — TEXT
- system_architecture_url — VARCHAR(255)
- skills — TEXT
- tools — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
ProjectLike
- id — BIGINT
- user_id — BIGINT — NOT NULL
- project_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- UNIQUE(user_id, — project_id)
User
- id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP