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