exhibition

Tables (3)

TABLE (PHOTO)

  • PK (pnum) — int — Primary key — NOT NULL
  • varchar(50) (ptitle) — String
  • varchar(30) (photographer) — String
  • varchar(1000) (pexplain) — String — NOT NULL
  • varchar(100) (photo) — String
  • int (photoview) — int
  • date (pdate) — String

TABLE (VISITOR)

  • PK (vid) — String — Primary key — NOT NULL
  • varchar(30) (vname) — String
  • date (visitDate) — String

TABLE (VISITORCOMMENT)

  • PK (vcnum) — int — Primary key — NOT NULL
  • FK (vid) — String — Foreign key → TABLE.PK — NOT NULL
  • FK (pnum) — int — Foreign key → TABLE.PK — NOT NULL
  • varchar(500) (vcomment) — String
  • date (vdate) — String