chronicle

Tables (4)

admins (관리자)

  • id (관리자 ID) — BIGINT — Primary key — NOT NULL
  • username (아이디) — VARCHAR — NOT NULL
  • password (비밀번호) — VARCHAR — NOT NULL
  • withdrawn (탈퇴여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — TIMESTAMPZ — NOT NULL

applications (애플리케이션)

  • id (애플리케이션 ID) — BIGINT — Primary key — NOT NULL
  • project_id (프로젝트 ID) — BIGINT — Foreign key → projects.id — NOT NULL
  • name (이름) — VARCHAR — NOT NULL
  • description (설명) — VARCHAR
  • deleted (삭제 여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — TIMESTAMPZ — NOT NULL
  • updated_at (수정일) — TIMESTAMPZ — NOT NULL

logs (로그)

  • id (로그 ID) — BIGINT — Primary key — NOT NULL
  • app_id (애플리케이션 ID) — BIGINT — Foreign key → applications.id — NOT NULL
  • level (레벨) — ENUM — NOT NULL
  • message (메시지) — TEXT
  • logger (로거 이름) — VARCHAR — NOT NULL
  • logged_at (발생 시간) — TIMESTAMPZ — NOT NULL

projects (프로젝트)

  • id (프로젝트 ID) — BIGINT — Primary key — NOT NULL
  • admin_id (관리자 ID) — BIGINT — Foreign key → admins.id — NOT NULL
  • api_key (API 키) — UUID — NOT NULL
  • name (이름) — VARCHAR — NOT NULL
  • description (설명) — VARCHAR
  • deleted (삭제 여부) — BOOLEAN — NOT NULL
  • created_at (생성일) — TIMESTAMPZ — NOT NULL
  • updated_at (수정일) — TIMESTAMPZ — NOT NULL