erp
Tables (19)
approvals (Untitled8)
- id — SERIAL — Primary key — NOT NULL
- creator_id — UUID — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- doc_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
attendances (Untitled4)
- id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- date — DATE — NOT NULL — Unique
- start_time — TIMESTAMP
- end_time — TIMESTAMP
- work_hours — INTERVAL
departments (Untitled)
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
drafts (Untitled10)
- id — SERIAL — Foreign key → approvals.id — NOT NULL
- approver_id — UUID — Foreign key → users.id — NOT NULL
- rejection_reason — TEXT
- price — integer
- date — DATE
- pdf_path — TEXT
expense_attachments (Untitled11)
- id — SERIAL — Primary key — NOT NULL
- expense_id — SERIAL — Foreign key → expense_reports.id — NOT NULL
- file_name — VARCHAR(255)
- file_path — TEXT
- file_type — VARCHAR(20)
expense_reports (Untitled9)
- id — SERIAL — Foreign key → approvals.id — NOT NULL
- approver_id — UUID — Foreign key → users.id — NOT NULL
- rejection_reason — TEXT
- price — integer
- date — DATE
- pdf_path — TEXT
leave_type (Untitled5)
- id — SERIAL — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
leaves (Untitled6)
- id — SERIAL — Primary key — NOT NULL
- leave_type_id — SERIAL — Foreign key → leave_type.id — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- approver_id — UUID — Foreign key → users.id
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- days — NUMERIC(4,1)
- reason — TEXT — NOT NULL
- approved_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- rejection_reason — TEXT
notice (Untitled12)
- id — SERIAL — Primary key — NOT NULL
- writer_id — UUID — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- title — VARCHAR(255)
- content — TEXT
- is_pinned — BOOLEAN
- is_deleted — BOOLEAN
notice_attachments (Untitled14)
- id — SERIAL — Primary key — NOT NULL
- notice_id — SERIAL — Foreign key → notice.id — NOT NULL
- file_name — VARCHAR(255)
- file_path — TEXT
- file_type — VARCHAR(20)
notice_comments (Untitled13)
- id — SERIAL — Primary key — NOT NULL
- notice_id — SERIAL — Foreign key → notice.id — NOT NULL
- parent_id — SERIAL — Foreign key → notice_comments.id — NOT NULL
- writer_id — UUID — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
notification (Untitled19)
- id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- type — VARCHAR(50)
- title — VARCHAR(255)
- content — TEXT
- link — VARCHAR(255)
- is_read — BOOLEAN
- created_at — TIMESTAMP
profile (Untitled7)
- id — SERIAL — Primary key — NOT NULL
- user_id — UUID — Foreign key → users.id — NOT NULL
- file_path — TEXT — NOT NULL
- file_name — TEXT
- updated_at — TIMESTAMP — NOT NULL
roles (Untitled2)
- id — SERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
task_attachments (Untitled18)
- id — SERIAL — Primary key — NOT NULL
- task_id — SERIAL — Foreign key → task_details.id — NOT NULL
- file_name — VARCHAR(255)
- file_path — TEXT
- file_type — VARCHAR(20)
task_comments (Untitled17)
- id — SERIAL — Primary key — NOT NULL
- parent_id — SERIAL — Foreign key → task_comments.id — NOT NULL
- task_id — SERIAL — Foreign key → task_details.id — NOT NULL
- writer_id — UUID — Foreign key → users.id — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
task_details (Untitled16)
- id — SERIAL — Primary key — NOT NULL
- task_id — SERIAL — Foreign key → tasks.id — NOT NULL
- content — TEXT
- participants — TEXT
tasks (Untitled15)
- id — SERIAL — Primary key — NOT NULL
- writer_id — UUID — Foreign key → users.id — NOT NULL
- title — VARCHAR(255)
- status — VARCHAR(20)
- start_date — DATE
- end_date — DATE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users (Untitled3)
- id — UUID — Primary key — NOT NULL
- dept_id — SERIAL — Foreign key → departments.id — NOT NULL
- role_id — SERIAL — Foreign key → roles.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- hire_date — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL