crepe
Tables (8)
branch (Untitled2)
- id — INT — Primary key — NOT NULL
- project_id — INT — Foreign key → project.id — NOT NULL
- uuid — char(36)
- name
feedback (Untitled7)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- log_id — INT — Foreign key → branch.id — NOT NULL
- uuid — char(36)
- message — varchar
layer
- id — INT — Primary key — NOT NULL
- log_id — INT — Foreign key → log.id — NOT NULL
- resource_id — INT — Foreign key → resource.id — NOT NULL
- 레이어순서 (sequence) — INT
log (Untitled4)
- id — INT — Primary key — NOT NULL
- branch_id — INT — Foreign key → branch.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- uuid — char(36)
- message — varchar
- preview — varchar
project (Untitled3)
- id — INT — Primary key — NOT NULL
- uuid — char(36)
- name
- intro
- preview
resource
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- name — varchar(200)
- link — varchar(200)
- uuid — char(36)
user
- id — INT — Primary key — NOT NULL
- uuid — char(36)
- email
- password
- nickname
- photo
user-project (Untitled6)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- project_id — INT — Foreign key → project.id — NOT NULL
- is_admin — TINYINT