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