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