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