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