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)