PopBob
Tables (7)
Comment
- cmtID (cmtId) — int — Primary key — NOT NULL
- BoardID (boardID) — int — Foreign key → Review.BoardID — NOT NULL
- ID (Key) — varchar(50) — Foreign key → Review.ID — NOT NULL
- UserID (userId) — int
- Content (content) — varchar(50)
- Wdate (wdate) — datetime
- Like (like) — int
Exhibition
- seq (Key) — int — Primary key — NOT NULL
- ename — varchar(100)
- period — varchar(100)
- etime — varchar(100)
- eloc — varchar(300)
- econtext — varchar(2000)
- eprice — varchar(50)
- imagename — varchar(50)
- imagesize — int
- ehit — int
- erec — int
Member
- ID (Key) — varchar(50) — Primary key — NOT NULL
- Password (password) — varchar(200)
- Email (email) — varchar(50)
- Nickname (nickname) — varchar(50)
Review
- BoardID (boardID) — int — Primary key — NOT NULL
- ID (Key) — varchar(50) — Foreign key → Member.ID — NOT NULL
- Title (title) — varchar(50)
- Type (type) — varchar(50)
- Writer (writer) — varchar(50)
- Wdate (wdate) — datetime
- Hit (hit) — int
- Content (content) — varchar(2000)
- Filename (filename) — varchar(50)
- Filesize (filesize) — int
ehbimage
- seq (Key) — int — Primary key — NOT NULL
- seq (Key2) — int — Foreign key → Exhibition.seq — NOT NULL
- imagename1 — varchar(50)
- imagename2 — varchar(50)
- imagename3 — varchar(50)
- imagesize1 — int
- imagesize2 — int
- imagesize3 — int
pop
- seq (Key) — int — Primary key — NOT NULL
- pname — varchar(100)
- period — varchar(100)
- ptime — varchar(100)
- ploc — varchar(300)
- pcontext — varchar(2000)
- imagename — varchar(50)
- imagesize — int
- phit — int
- prec — int
popimage
- seq (Key) — int — Primary key — NOT NULL
- seq (Key2) — int — Foreign key → pop.seq — NOT NULL
- imagename1 — varchar(50)
- imagename2 — varchar(50)
- imagename3 — varchar(50)
- imagesize1 — int
- imagesize2 — int
- imagesize3 — int