ㅂㅈㄷ

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 — 메시지 전송 일시