Devsign

Tables (13)

APPLICANT (프로젝트 지원)

  • 지원 PK (applicant_id) — BIGINT — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • 회원 PK (member_id) — BIGINT — Foreign key → MEMBER.회원 PK — NOT NULL

GROUP_CHAT (그룹채팅)

  • 채팅 PK (group_chat_id) — BIGINT — Primary key — NOT NULL
  • 프로젝트 PK (project_pk) — BIGINT — Foreign key → PROJECT.프로젝트 PK — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

MEMBER (회원)

  • 회원 PK (member_id) — BIGINT — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

MESSAGE (메시지)

  • 메시지 PK (message_id) — BIGINT — Primary key — NOT NULL
  • 그룹 PK (group_chat_id) — BIGINT — Foreign key → PARTICIPANT.그룹 PK — NOT NULL
  • 지원 PK (applicant_id) — BIGINT — Foreign key → PARTICIPANT.지원 PK — NOT NULL
  • 채팅 PK (group_chat_id2) — BIGINT — Foreign key → GROUP_CHAT.채팅 PK — NOT NULL
  • 프로젝트 PK (project_pk) — BIGINT — Foreign key → GROUP_CHAT.프로젝트 PK — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

PARTICIPANT (프로젝트 참여자)

  • 그룹 PK (group_chat_id) — BIGINT — Foreign key — NOT NULL
  • 지원 PK (applicant_id) — BIGINT — Foreign key → APPLICANT.지원 PK — NOT NULL
  • Field2
  • Field3
  • Field4

PROJECT (프로젝트)

  • 프로젝트 PK (project_pk) — BIGINT — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

applicant

  • applicant_id — BIGSERIAL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

group_chat

  • group_chat_id — BIGSERIAL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • Field

member

  • member_id — BIGSERIAL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • section — VARCHAR(20) — NOT NULL
  • reputation — INTEGER — NOT NULL
  • profile_data — TEXT
  • created_at — TIMESTAMP — NOT NULL

message

  • message_id — BIGSERIAL
  • group_chat_id — BIGINT — Foreign key → group_chat.group_chat_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notification

  • notification_id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • related_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

project

  • project_id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • main_title — VARCHAR(100) — NOT NULL
  • subtitle — VARCHAR(200)
  • content — TEXT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • needed_developers — INTEGER — NOT NULL
  • needed_designers — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

review

  • review_id — BIGSERIAL
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • reviewer_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • reviewee_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • content — TEXT — NOT NULL
  • rating — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL