hanbook

Tables (5)

Book (Untitled)

  • BookID (Key) — int(100) — Primary key — NOT NULL
  • sellerpost (Key2) — int(50) — Foreign key → BookPost.sellerpost — NOT NULL
  • title (Field) — varchar(100) — NOT NULL
  • Category (Field2) — varchar(10) — NOT NULL
  • Author (Field3) — varchar(20)
  • Status (Field4) — varchar(5)
  • HandwritingLevel (Field5) — int(10)
  • PublishingHouse (Field6) — varchar(100)
  • IsSold (Field7) — boolean
  • SellingPrice (Field8) — int(100)

BookPost (Untitled5)

  • sellerpost (Key) — int(50) — Primary key — NOT NULL
  • count (Field) — int(50)

Chatting (Untitled3)

  • PostNo (Key3) — int(500) — Foreign key → Post.PostNo — NOT NULL
  • sellerpost (Key2) — int(50) — Foreign key → Post.sellerpost — NOT NULL
  • ID (Key) — varchar(20) — Foreign key → Trader.ID — NOT NULL
  • Date (Field) — date
  • Time (Field2) — time
  • Contents (Field3) — varchar(100)

Post (Untitled2)

  • PostNo (Key) — int(500) — Primary key — NOT NULL
  • ID (Key3) — varchar(20) — Foreign key → Trader.ID — NOT NULL
  • sellerpost (Key2) — int(50) — Foreign key → BookPost.sellerpost — NOT NULL
  • Title (Field) — varchar(100)
  • Contents (Field2) — varchar(100)
  • Date (Field3) — date
  • PickMark (Field5) — boolean
  • AttachedFile (Field6) — image

Trader (Untitled4)

  • ID (Key) — varchar(20) — Primary key — NOT NULL
  • Name (Field) — varchar(20)
  • PW (Field2) — varchar(20)
  • SchoolEmail (Field3) — varchar(20)
  • UserType (Field4) — char(1)