Database Architecture & ORM Tooling

Visualizer ERD Database & Schema Generator SQL / Prisma

Rancang struktur entitas dan relasi database secara visual. Tambahkan tabel, kunci primer, foreign key, dan ekspor instan ke skrip PostgreSQL DDL, MySQL, atau Prisma Schema.

Diagram Relasi Entitas (3 Tabel)

users

UUID

VARCHAR(255)

company_name

VARCHAR(255)

created_at

TIMESTAMP

quotations

UUID

user_id→ users.id

UUID

total_budget_idr

BIGINT

sla_target_hours

INTEGER

status

VARCHAR(50)

created_at

TIMESTAMP

audit_logs

BIGSERIAL

user_id→ users.id

UUID

action

VARCHAR(100)

ip_address

INET

logged_at

TIMESTAMP

-- PostgreSQL DDL Schema Generated by PuluhLabs ERD Studio

CREATE TABLE users (
  id                   UUID PRIMARY KEY,
  email                VARCHAR(255) UNIQUE NOT NULL,
  company_name         VARCHAR(255),
  created_at           TIMESTAMP NOT NULL
);

CREATE TABLE quotations (
  id                   UUID PRIMARY KEY,
  user_id              UUID NOT NULL,
  total_budget_idr     BIGINT NOT NULL,
  sla_target_hours     INTEGER NOT NULL,
  status               VARCHAR(50) NOT NULL,
  created_at           TIMESTAMP NOT NULL
);

ALTER TABLE quotations ADD CONSTRAINT fk_quotations_user_id FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;

CREATE TABLE audit_logs (
  id                   BIGSERIAL PRIMARY KEY,
  user_id              UUID NOT NULL,
  action               VARCHAR(100) NOT NULL,
  ip_address           INET NOT NULL,
  logged_at            TIMESTAMP NOT NULL
);

ALTER TABLE audit_logs ADD CONSTRAINT fk_audit_logs_user_id FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE;