KEEFO APP

테이블 (20)

고객 (customer)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (industryCode) — Int — 외래 키 → 산업군.Key — NOT NULL
  • Key (id2) — Int — 외래 키 → 산업군.Key — NOT NULL
  • Key (id22) — Int — 외래 키 → 산업군.Key — NOT NULL
  • Field (created) — DateTime
  • Field (modified) — DateTIme
  • Field (status) — Boolean
  • Field (industyId) — Int
  • Field (versionCode) — Int
  • Field (countryCode) — Int
  • Field (code) — Int
  • Field (maxProjectCode) — Int
  • Field (apiKey) — String
  • Field (apiSecret) — String
  • Field (isAdmin) — Boolean
  • Field (name) — String
  • Field (description) — String
  • Field (call) — String
  • Field (businessNumber) — String
  • Field (homepage) — String
  • Field (address) — String
  • Field (managerName) — String
  • Field (managerEmail) — String
  • Field (managerPhone) — String
  • Field (logoImageUrl) — String
  • Field (businessImageUrl) — String

국가 (country)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (versionCode) — Int — 외래 키 → 버전.Key — NOT NULL
  • Field (status) — Boolean
  • Field (versionId) — Int
  • Field (code) — Int
  • Field (name) — String
  • Field (maxIndustryCode) — Int

버전 (version)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (status) — Boolean
  • Field (code) — Int
  • Field (name) — String
  • Field (maxCountryCode) — Int
  • Field (country) — country[]

사전예약 (preReservation)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (eventId) — Int
  • Field (eventSessionId) — Int
  • Field (email) — String
  • Field (name)

산업군 (industry)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (countryCode) — Int — 외래 키 → 국가.Key — NOT NULL
  • Key (id2) — Int — 외래 키 → 국가.Key — NOT NULL
  • Field (status) — Boolean
  • Field (countryId) — Int
  • Field (versionCode) — Int
  • Field (code) — Int
  • Field (name) — String
  • Field (maxCustomerCode) — Int
  • Field (country) — Country
  • Field (customer) — Customer[]

상품수령 (embeddingProductReceipt)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field2 (userId) — Int
  • Field (embeddingProductId) — Int

스캔 (scans)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (embeddingProductId) — Int
  • Field (productType) — ProductType
  • Field (eventId) — Int
  • Field (hommaId) — Int

오늘의 소식 (newsToday)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (title) — String
  • Field (imageUrl) — String

유저 (user)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (deviceId) — Int
  • Field (profile) — string

유저캐치프레이즈 (userCatchphrase)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (catchphraseId) — Int
  • Field (userId) — Int

이벤트 (event)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (name) — String

이벤트 세션 (eventSession)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (eventDate) — Int
  • Field (eventId) — Int

이벤트 홈마 (eventHomma)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (eventId) — Int
  • Field (hommaId) — Int
  • Field (name) — String

이벤트참여 (embeddingParticipation)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (userId) — Int
  • Field (email) — String

임베딩 제품 (embeddingProduct)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (eventId) — Int
  • Field (hommaId) — Int
  • Field (projectId) — Int
  • Field (code) — Int

임베딩제품랭크 (embeddingProductRank)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (embeddingProductId) — Int
  • Field (rank) — string

출입용임베딩코드 (userLabCheckInProduct)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (embeddingProductId) — Int
  • Field (sessionId) — Int
  • Field (userId) — Int
  • Field (eventId) — Int

캐치프레이즈 (catchphrase)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (name) — String

프로젝트 (proejct)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (customerCode) — Int — 외래 키 → 고객.Key — NOT NULL
  • Key (id2) — Int — 외래 키 → 고객.Key — NOT NULL
  • Key (id22) — Int — 외래 키 → 고객.Key — NOT NULL
  • Key (id222) — Int — 외래 키 → 고객.Key — NOT NULL
  • Field (created) — DateTime
  • Field (modified) — DateTime
  • Field (status) — Boolean
  • Field (customerId) — Int
  • Field (versionCode) — Int
  • Field (countryCode) — Int
  • Field (industryCode) — Int
  • Field (code) — Int
  • Field (maxProductCode) — BigInt
  • Field (description) — String
  • Field (bannerImageUrl) — String
  • Field (mainCategoryId) — MainCategory
  • Field (subCategory) — subCategory
  • Field (scan) — Scan[]

홈마 (homma)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (homma) — String