Vinopool
테이블 (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