RaffleADMIN

Tables (7)

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

RaffleStoreManualWinner (raffle_store_manual_winner)

  • id (Key) — bgint — Primary key — NOT NULL
  • raffleStoreId (key) — bgint — Foreign key → RaffleStore.id — NOT NULL
  • id (Key2) — bgint — Foreign key → UserSeoul.id — NOT NULL
  • userEntranceNumber (Field) — bgint
  • deleted (Field2) — Boolean
  • createdAt (Field3) — LocalDateTime
  • updatedAt (Field4) — 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

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

WaitingStoreUser (waiting_store_user)

  • id (Key) — bgint — Primary key — NOT NULL
  • userRaffleStoreId (Key2) — bgint — Foreign key → WaitingStore.id — NOT NULL
  • entranceCode (Field) — bgint
  • type (Field2) — WaitingStoreUserType
  • status (Field3) — WaitingStoreUserStatus
  • phone (Field4) — String
  • email (Field5) — String
  • countryCode (Field6) — String
  • ip (Field7) — String
  • messageSentAt (Field8) — LocalDateTime
  • createdAt (Field9) — LocalDateTime
  • updateAt (Field10) — LocalDateTime