ㅂㅈㄷ
Tables (11)
Comment
- comment_id — BIGINT — Primary key — NOT NULL
- task_id — BIGINT — Foreign key → Task.task_id — NOT NULL
- content — TEXT — NOT NULL
- author_member_id — VARCHAR(50) — NOT NULL
Department
- dep_code — VARCHAR(10) — Primary key — NOT NULL
- dep_name — VARCHAR(20)
EmpDep
- id — BIGINT — Foreign key → Employee.id — NOT NULL
- dep_code — VARCHAR(10) — Foreign key → Department.dep_code — NOT NULL
Employee
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(20)
MileStone
- milestone_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → Project.project_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
Project
- project_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- admin_member_id — VARCHAR(50) — NOT NULL
Project_Member
- project_member_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → Project.project_id — NOT NULL
- member_id — VARCHAR(50) — NOT NULL
Tag
- tag_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → Project.project_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
Task
- task_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → Project.project_id — NOT NULL
- milestone_id — BIGINT — Foreign key → MileStone.milestone_id
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- author_member_id — VARCHAR(50) — NOT NULL
Task_Tag
- task_tag_id — BIGINT — Primary key — NOT NULL
- task_id — BIGINT — Foreign key → Task.task_id — NOT NULL
- tag_id — BIGINT — Foreign key → Tag.tag_id — NOT NULL
chat_log
- id — BIGSERIAL — Primary key — NOT NULL — 로그 고유 식별자 (자동 증가)
- user_id — BIGINT — NOT NULL — 회원 식별자 (질문한 사용자)
- cultivation_id — BIGINT — 경작 식별자 (내 농가 센서/리포트 관련 질문 시 매핑, 일반 질문 시 NULL)
- sender_role — VARCHAR(20) — NOT NULL — 발신자 주체 (USER / ASSISTANT)
- content — TEXT — NOT NULL — 대화 본문 (명령어 또는 AI 응답 텍스트)
- created_at — TIMESTAMP — NOT NULL — 메시지 전송 일시