RaffleUser
Tables (6)
RaffleStore (raffle_store)
- id (key) — bgint — Primary key — NOT NULL
- waitingStoreId (Key) — bgint — Foreign key → WaitingStore.id — NOT NULL
- mainImageUrl (Field) — String
- status (Field2) — RaffleProductStatus
- visible (Field3) — boolean
- visibleFrom (Field4) — LocalDataTime
- visibleUntil (Field5) — LocalDataTime
- isAuto (Field6) — boolean
- autoRaffleSelectTime (Field7) — LocalDateTime
- autoRaffleSelectCount (Field8) — Long
- createAt (Field9) — LocalDateTime
RaffleStoreReservation (raffle_store_reservation)
- id (Key) — bgint — Primary key — NOT NULL
- raffleStoreID (KEY) — bgint — Foreign key → RaffleStore.id — NOT NULL
- reservationTime (Field) — String
- completed (Field2) — boolean
- deleted (Field3) — boolean
- createdAt (Field4) — LocalDateTime
- updateAt (Field5) — LocalDateTime
Store (stores)
- id (Key) — bgint — Primary key — NOT NULL
- onlineStore (Field) — ENUM
- storeCode (Field2) — String
- shoreCode (Field3) — String
- name (Field4) — String
- shortName (Field5) — String
- visible (Field6)
UserRaffleStore (user_raffle_store)
- Key — bgint — Primary key — NOT NULL
- userSeoulId (Key2) — bgint — Foreign key → UserSeoul.id — NOT NULL
- raffleStoreId (key3) — bgint — Foreign key → RaffleStore.id — NOT NULL
- raffleStoreReservationId (Key4) — bgint — Foreign key → RaffleStoreReservation.id — NOT NULL
- status (Field) — UserRaffleStatus
- winingType (Field2) — UserRaffleWiningType
- resultAt (Field3) — LocalDateTime
- createdAt (Field4) — LocalDateTime
- updateAt (Field5) — LocalDateTime
UserSeoul (user_seoul)
- id (Key) — bgint — Primary key — NOT NULL
- store (field) — OrderStore
- name (Field2) — String
- birth (Field3) — String
- phone (Field4) — String
- email (Field5) — String
- countryCode (Field6) — String
- isBlack (Field7) — boolean
- createAt (Field8) — LocalDateTime
- updateAt (Field9) — LocalDateTime
WaitingStore (waiting_store)
- id (Key) — bgint — Primary key — NOT NULL
- raffleStoreId (key) — bgint — Foreign key → RaffleStore.id — NOT NULL
- imageUrl (Field) — String
- password (Field2) — String
- mode (Field3) — WaitingStoreMode
- isSetWatingTime (Field4) — boolean
- waitingMaxLimit (Field5) — Long
- waitingTime (Field6) — Long
- waitingTimeMaxLimit (Field7) — Long
- phonePerUser (Field8) — boolean
- applyAll (Field9) — boolean
- status (Field10) — boolean
- createAt (Field11) — LocalDateTime
- updateAt (Field12) — LocalDateTime