JTIP
Tables (5)
analysis_results (Untitled4)
- id (Key) — INT — Primary key — NOT NULL
- project_data_id (Key2) — INT — Foreign key → project_data.id — NOT NULL
- analyzer_id (Key3) — INT — Foreign key → users.id — NOT NULL
- frame_no (Field) — INT
- base_no (Field2) — INT
- result (Field3) — JSON — NOT NULL
- created_at (Field4) — TIMESTAMP
audit_logs (Untitled5)
- id (Key) — INT — Primary key — NOT NULL
- user (Field6) — INT
- action (Field) — VARCHAR(50) — NOT NULL — CREATE / UPDATE / DELETE 등
- target_table (Field2) — VARCHAR(50)
- target_id (Field3) — INT
- detail (Field4) — JSON
- created_at (Field5) — TIMESTAMP — NOT NULL
project_data (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- project_id (Key2) — INT — Foreign key → projects.id — NOT NULL
- file_path (Field) — TEXT
- file_name (Field2) — VARCHAR(255)
- view_type (Field3) — VARCHAR(10)
- created_at (Field4) — TIMESTAMP
- config (Field5) — JSON
projects (Untitled2)
- id (Key) — INT — Primary key — NOT NULL
- owner_id (Key2) — INT — Foreign key → users.id — NOT NULL
- name (Field) — VARCHAR(255) — NOT NULL
- device_type (Field2) — VARCHAR(100) — NOT NULL
- description (Field3) — TEXT
- created_at (Field4) — TIMESTAMP — NOT NULL
users (Untitled)
- id (Key) — INT — Primary key — NOT NULL
- login_id (Field2) — VARCHAR(100) — NOT NULL
- password_hash (Field) — VARCHAR(255) — NOT NULL
- name (Field6) — VARCHAR(100)
- department (Field3) — VARCHAR(255) — NOT NULL
- is_admin (Field4) — boolean — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL
- state (Field7) — VARCHAR(100)