CyberFunc

Tables (4)

Admin User (Untitled)

  • _id — string — Foreign key → User._id — NOT NULL
  • password (Field)
  • isAdmin (Field2)

Book_Info (Untitled4)

  • _id (Key) — number — Primary key — NOT NULL
  • title (Field) — string
  • author (Field2) — string
  • publisher (Field3) — string
  • genre (Field4) — string
  • price (Field5) — number
  • introduce (Field6) — string
  • arrival_date (Field7) — Date
  • stock_quantity (Field8) — string
  • remain_stock (Field9) — number
  • sold_stock (Field10) — number
  • hash_tags (Field11) — string Array

User (Untitled2)

  • _id — string — Primary key — NOT NULL
  • password (Field) — string
  • phone (Field2) — number
  • address (Field3) — string
  • isAdmin (Field4) — boolean

payment (Untitled3)

  • Key — Primary key — NOT NULL
  • Book_id (Key2) — Foreign key → Book_Info._id — NOT NULL
  • User_id (Key3) — Foreign key → User._id — NOT NULL
  • price (Field)
  • address (Field2)
  • amount (Field3)
  • date (Field4)