erd

Tables (5)

company

  • id — INT — Primary key — NOT NULL
  • public_id — BINARY(16) — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

member

  • id — INT — Primary key — NOT NULL
  • public_id — BINARY(16) — NOT NULL
  • company_id — INT
  • email — VARCHAR(190) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — ENUM('ADMIN','OWNER','STAFF') — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

project

  • id — INT — Primary key — NOT NULL
  • id (id2) — INT — Foreign key → company.id — NOT NULL
  • public_id — BINARY(16) — NOT NULL
  • company_id — INT — NOT NULL
  • name — VARCHAR(140) — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

project_key

  • project_id — INT — Primary key — NOT NULL
  • id (id2) — INT — Foreign key → project.id — NOT NULL
  • token_hash — VARCHAR(128) — NOT NULL
  • status — ENUM('ACTIVE','REVOKED','EXPIRED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • expires_at — DATETIME(3)

project_member

  • project_id — INT — Primary key — NOT NULL
  • member_id — INT — Primary key — NOT NULL
  • id (id2) — INT — Foreign key → project.id — NOT NULL
  • id (id3) — INT — Foreign key → member.id — NOT NULL
  • id (id22) — INT — Foreign key → project.id — NOT NULL
  • role — ENUM('OWNER','STAFF') — NOT NULL
  • status — ENUM('ACTIVE','INACTIVE','DELETED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL