Maladin

Tables (20)

Author (Untitled18)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — NVARCHAR(255) — NOT NULL
  • Introduce (Field2) — NVARCHAR(MAX)

Book (Untitled6)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Isbn (Field) — VARCHAR(20) — NOT NULL
  • Stock (Field3) — INTEGER — NOT NULL
  • Sales (Field10) — INTEGER — NOT NULL
  • Price (Field2) — INTEGER — NOT NULL

BookBox (Untitled12)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • BookId (Key3) — INTEGER — Foreign key → Book.Id — NOT NULL

BookCategory (Untitled7)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • ParentId (Key2) — INTEGER — Foreign key → BookCategory.Id
  • Name (Field) — NVARCHAR(255) — NOT NULL

BookDisplay (Untitled21)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • BookId (Key7) — INTEGER — Foreign key → Book.Id — NOT NULL
  • AuthorId (Key4) — INTEGER — Foreign key → Author.Id — NOT NULL
  • TranslatorId (Key5) — INTEGER — Foreign key → Translator.Id — NOT NULL
  • PublisherId (Key3) — INTEGER — Foreign key → Publisher.Id — NOT NULL
  • CategoryId (Key6) — INTEGER — Foreign key → BookCategory.Id — NOT NULL
  • Title (Field) — NVARCHAR(MAX) — NOT NULL
  • Overview (Field2) — NVARCHAR(MAX) — NOT NULL
  • PaperSize (Field3) — VARCHAR(255) — NOT NULL
  • PageCount (Field4) — INTEGER — NOT NULL
  • CoverUrl (Field5) — VARCHAR(MAX) — NOT NULL
  • PublishAt (Field8) — DATETIMEOFFSET(7) — NOT NULL

BookReview (Untitled10)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • BookId (Key3) — INTEGER — Foreign key → Book.Id — NOT NULL
  • Content (Field) — NVARCHAR(MAX) — NOT NULL
  • Rating (Field2) — INTEGER — NOT NULL
  • CreatedAt (Field3) — DATETIMEOFFSET(7) — NOT NULL

BookReviewComment (Untitled11)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • ReviewId (Key2) — INTEGER — Foreign key → BookReview.Id — NOT NULL
  • UserId (Key3) — INTEGER — Foreign key → User.Id — NOT NULL
  • Content (Field) — NVARCHAR(MAX) — NOT NULL

Delivery (Untitled14)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — NVARCHAR(255) — NOT NULL

IamportPayment (Untitled20)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • OrderId (Key2) — INTEGER — Foreign key → Order.Id — NOT NULL
  • ImpUid (Field) — VARCHAR(255) — NOT NULL
  • Amount (Field2) — INTEGER — NOT NULL
  • PgProvider (Field3) — VARCHAR(255) — NOT NULL

Membership (Untitled22)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Level (Field) — INTEGER — NOT NULL
  • PointPercentage (Field2) — INTEGER — NOT NULL

OAuthId (Untitled3)

  • Id (Key3) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • ProviderId (Key) — INTEGER — Foreign key → OAuthProvider.Id — NOT NULL
  • NameIdentifier (Field) — VARCHAR(MAX) — NOT NULL

OAuthProvider (Untitled2)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — NVARCHAR(255) — NOT NULL

Order (Untitled13)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • DeliveryId (Key4) — INTEGER — Foreign key → Delivery.Id
  • UsedPoint (Field6) — INTEGER
  • OrderedAt (Key3) — DATETIMEOFFSET(7) — NOT NULL
  • Address (Field3) — NVARCHAR(MAX) — NOT NULL
  • Postcode (Field9) — VARCHAR(255) — NOT NULL
  • InvoiceNumber (Field) — VARCHAR(255) — NOT NULL
  • ReceiverName (Field4) — NVARCHAR(255) — NOT NULL
  • Message (Field2) — NVARCHAR(255)
  • PhoneNumber (Field5) — NVARCHAR(255) — NOT NULL
  • State (Field8) — VARCHAR(255) — NOT NULL

OrderBook (Untitled15)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • BookId (Key2) — INTEGER — Foreign key → Book.Id — NOT NULL
  • OrderId (Key3) — INTEGER — Foreign key → Order.Id — NOT NULL
  • OrderQty (Field) — INTEGER — NOT NULL
  • RefundQty (Field3) — INTEGER
  • PricePerItem (Field2) — INTEGER — NOT NULL

Point (Untitled5)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • Amount (Field2) — INTEGER — NOT NULL
  • Balance (Field3) — INTEGER — NOT NULL
  • ExpireAt (Field) — DATETIMEOFFSET(7) — NOT NULL

Publisher (Untitled8)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — NVARCHAR(255) — NOT NULL
  • Introduce (Field2) — NVARCHAR(MAX)

Role (Untitled4)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — VARCHAR(255) — NOT NULL
  • Priority (Field2) — INTEGER — NOT NULL

Translator (Untitled19)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • Name (Field) — NVARCHAR(255) — NOT NULL
  • Introduce (Field2) — NVARCHAR(MAX)

User (Untitled)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • RoleId (Key3) — INTEGER — Foreign key → Role.Id — NOT NULL
  • MembershipId (Key2) — INTEGER — Foreign key → Membership.Id — NOT NULL
  • Name (Field) — NVARCHAR(20) — NOT NULL
  • Email (Field3) — VARCHAR(255) — NOT NULL
  • PasswordHash (Field2) — VARCHAR(MAX)
  • SignupAt (Field4) — DATETIMEOFFSET(7) — NOT NULL
  • SignupIp (Field5) — VARCHAR(255) — NOT NULL
  • UpdatedAt (Field6) — DATETIMEOFFSET(7)
  • UpdateIp (Field7) — VARCHAR(255)
  • LastLoginAt (Field12) — DATETIMEOFFSET(7)
  • LastLoginIp (Field13) — VARCHAR(255)
  • IsExpired (Field9) — BIT — NOT NULL
  • IsLocked (Field10) — BIT — NOT NULL
  • IsEmailAuthenticated (Field11) — BIT — NOT NULL
  • IsOAuth (Field14) — BIT — NOT NULL

UserAddress (Untitled9)

  • Id (Key) — INTEGER — Primary key — NOT NULL
  • UserId (Key2) — INTEGER — Foreign key → User.Id — NOT NULL
  • Address (Field) — NVARCHAR(MAX) — NOT NULL
  • Postcode (Field3) — VARCHAR(255) — NOT NULL
  • IsDefault (Field2) — BIT — NOT NULL