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)