HG's project

테이블 (16)

Copy Of Copy Of Copy Of Copy Of 이벤트2 (Products)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT
  • Field (priority) — Number
  • Field (startDate) — Date
  • Field (endDate) — Date
  • Field (price) — Number
  • Field (totalQuantity) — Number
  • Field (bookableQuantity) — Number
  • Field (isNeededAddition) — Boolean

Copy Of Copy Of Copy Of 이벤트2 (Wines)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT
  • Field (wineName) — String
  • Field (sweet) — Number
  • Field (acidity) — Number
  • Field2 (body) — Number
  • Field3 (tannin) — Number

Copy Of Copy Of 이벤트2 (Keywords)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT

Copy Of Untitled (WineType)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (wine) — Number — 외래 키 → Copy Of Copy Of Copy Of 이벤트2.id — NOT NULL — AUTO_INCREMENT

Copy Of Untitled2 (WineTypeLocales)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • Key (wineType) — Number — 외래 키 → Copy Of Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Field (wineTypeName) — String

Copy Of Untitled3 (payment)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • Key (booking) — Number — 외래 키 → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Field (totalPrice) — Number
  • Field2 (payStatus) — Enum
  • Field (payMethod) — Enum
  • Field (paidDateTime) — Date
  • Field (refundDateTime) — Date

Copy Of 이벤트 (EventLocales)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT
  • eventName — String
  • Field3 (price) — String
  • Field (originalPrice) — String
  • Field (date) — String
  • Field4 (location) — String — 자세한 위치(place?)
  • Field5 (groupSize) — String — 최대 인원
  • Field6 (tastingOption) — String
  • Field7 (target) — String
  • Field8 (supportLanguage) — String
  • section1 (introduction) — Text — 첫 번째 섹션
  • Field10 (addition) — Text — 두 번째 섹션
  • Field11 (notice) — Text — 세 번째 섹션

Copy Of 이벤트2 (Regions)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT

Untitled (RegionLocales)

  • Key (id) — Number — 기본 키 — NOT NULL
  • id (regionName) — String — 외래 키 → Copy Of 이벤트2.id — NOT NULL — AUTO_INCREMENT

Untitled (ProductLocales)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (product) — Number — 외래 키 → Copy Of Copy Of Copy Of Copy Of 이벤트2.id — NOT NULL — AUTO_INCREMENT
  • Field (productName) — String
  • Field (notice) — Text
  • Field (isBookable) — Boolean
  • Field (isShow) — Boolean

Untitled (WineLocales)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (wine) — Number — 외래 키 → Copy Of Copy Of Copy Of 이벤트2.id — NOT NULL — AUTO_INCREMENT
  • Field (wineName) — String
  • Field (introduction) — Text

Untitled (EventType)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (event) — Number — 외래 키 → 이벤트.id — NOT NULL — AUTO_INCREMENT

Untitled (EventTypeLocales)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • Key (eventType) — Number — 외래 키 → Untitled.Key — NOT NULL — AUTO_INCREMENT
  • Field (eventTypeName) — String

Untitled (eventBooking)

  • Key (id) — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • id (product) — Number — 외래 키 → Copy Of Copy Of Copy Of Copy Of 이벤트2.id — NOT NULL — AUTO_INCREMENT
  • Field (bookingId) — String — NOT NULL
  • Field2 (bookedQuantity) — Number
  • Field (bookedName) — String
  • Field (phoneNumber) — String
  • Field (email) — Email
  • Field (addition) — Text

언어 (Languages)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • languageCode — String — NOT NULL — ISO2 CODE
  • id (eventTanslation) — Number — 외래 키 → Copy Of 이벤트.id — NOT NULL
  • Key (regionTranslation) — Number — 외래 키 → Untitled.Key — NOT NULL
  • Key (productTranslation) — Number — 외래 키 → Untitled.Key — NOT NULL
  • Key (wineTranslation) — Number — 외래 키 → Untitled.Key — NOT NULL
  • Key (eventTypeTranslation) — Number — 외래 키 → Untitled.Key — NOT NULL
  • Key (wineTypeTranslation) — Number — 외래 키 → Copy Of Untitled2.Key — NOT NULL

이벤트 (Events)

  • id — Number — 기본 키 — NOT NULL — AUTO_INCREMENT
  • Field (address) — String
  • Field (thumbnailImage) — Media
  • Field (featuredImage)
  • Field (galleryImages) — Media
  • Field (sponsorImages) — Media