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