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