Genergy
Tables (3)
COMMENT (코멘트)
- comment_id (코멘트) — Bigserial — Primary key — NOT NULL
- user_id (사용자ID) — Bigserial — Foreign key → USER.user_id — NOT NULL
- content (내용) — text
- created_at (생성날짜) — Timestamp
ISSUE (이슈)
- issue_id (이슈ID) — Bigserial — Primary key — NOT NULL
- request_id (요청자ID) — bigint — Foreign key → USER.user_id — NOT NULL
- title (제목) — varchar(255)
- content (내용) — text
- severity (심각도) — integer
- category (분야) — enum
- created_at (요청일) — Timestamp
- palnned_at (계획예정일) — Timestamp
- completed_at (실제완료일) — Timestamp
- assignment_msg (할당메시지) — text
- status (상태) — enum
USER (사용자)
- user_id (사용자ID) — Bigserial — Primary key — NOT NULL
- login_id (아이디) — varchar(100)
- login_pw (비밀번호) — varchar(255)
- name (이름) — varchar(100)
- role (역할) — enum
- status (상태) — enum
- created_at (생성날짜) — Timestamp
- deleted_at (삭제날짜) — Timestamp
- email (이메일) — varchar(100)