Snaptag_New_DB

Tables (12)

Country (Untitled)

  • id (Key) — Primary key — NOT NULL
  • versionId (Key2) — Foreign key → Version.id — NOT NULL
  • code (Field2)

Customer (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • industryId (Key2) — Foreign key → Industry.id — NOT NULL
  • countryId (Key3) — Foreign key → Country.id — NOT NULL
  • versionId (Key4) — Foreign key → Version.id — NOT NULL
  • code (Field2)

Industry (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • countryId (Key2) — Foreign key → Country.id — NOT NULL
  • versionId (Key3) — Foreign key → Version.id — NOT NULL
  • code (Field2)

MaxCode (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • industryId (Key2) — Foreign key → Industry.id — NOT NULL
  • maxCustomerCode (Field2)
  • maxProjectCode (Field3)
  • maxProductCode (Field4)

Occupation (Untitled11)

  • id (Key) — Primary key — NOT NULL

Product (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • projectId (Key2) — Foreign key → Project.id — NOT NULL
  • userId (Key4) — Foreign key → User.id — NOT NULL
  • code (Field)
  • url (Field2)
  • isEmbedding (임베딩된 제품인지 확인)

Project (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • customerId (Key2) — Foreign key → Customer.id — NOT NULL
  • userId (Key3) — Foreign key → User.id — NOT NULL
  • versionId (Key4) — Foreign key → Version.id — NOT NULL
  • countryId (Key22) — Foreign key → Country.versionId — NOT NULL
  • industryId (Key32) — Foreign key → Industry.versionId — NOT NULL
  • code (Field)

TermsOfService (Untitled10)

  • id (Key) — Primary key — NOT NULL

User (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • occupationId (Key2) — Foreign key → Occupation.id — NOT NULL
  • role (Enum: ProgramAdmin, ProgramUser ...)

UserFile (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → User.id — NOT NULL

UserTermsOfService (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • id (userId) — Foreign key → User.id — NOT NULL
  • id (termsOfServiceId) — Foreign key → TermsOfService.id — NOT NULL

Version

  • id (Key) — Primary key — NOT NULL
  • code (Field)