fortuneApp

Tables (5)

Card

  • CardId — Long — Primary key — NOT NULL
  • Name
  • Orientation
  • CreatedAt — Datetime
  • UpdatedAt — Datetime
  • CreatedBy — Long
  • UpdatedBy — Long

CardInterpretation

  • CardInterpretationId — Long — Primary key — NOT NULL
  • CardId — Long — Foreign key → Card.CardId — NOT NULL
  • FortuneId — Long — Foreign key → Fortune.FortuneId — NOT NULL
  • InterpretationContent
  • CreatedAt — Datetime
  • UpdatedAt — Datetime
  • CreatedBy — Long
  • UpdatedBy — Long

CardLog

  • CardLogId — Long — Primary key — NOT NULL
  • UserId — Long — Foreign key → User.UserId — NOT NULL
  • CardInterpretationId — Long — Foreign key → CardInterpretation.CardInterpretationId — NOT NULL
  • CreatedAt — Datetime
  • UpdatedAt — Datetime
  • CreatedBy — Long
  • UpdatedBy — Long

Fortune

  • FortuneId — Long — Primary key — NOT NULL
  • Type
  • CreatedAt — Datetime
  • UpdatedAt — Datetime
  • CreatedBy — Long
  • UpdatedBy — Long

User

  • UserId — Long — Primary key — NOT NULL
  • Name
  • Nickname
  • Birth — Date
  • Provider
  • ProviderUid
  • AccessToken
  • RefreshToken
  • CreatedAt — Datetime
  • UpdatedAt — Datetime — NOT NULL
  • CreatedBy — Long
  • UpdatedBy — Long — NOT NULL