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