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)