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