POP/EXHI
Tables (10)
Image
- ImageId (imageId) — int — Primary key — NOT NULL
- InfoId (infoId) — int — Foreign key → Information.InfoId — NOT NULL
- Image1 (image1) — varchar(50)
- Image2 (image2) — varchar(50)
- Image3 (image3) — varchar(100)
- Image4 (image4) — varchar(50)
Information
- InfoId (infoId) — int — Primary key — NOT NULL
- Title (title) — varchar(100)
- Content (content) — varchar(2000)
- Category (category) — varchar(100)
Location
- LocId (locId) — int — Primary key — NOT NULL
- InfoId (infoId) — int — Foreign key → Information.InfoId — NOT NULL
- ResID (resId) — int — Foreign key → Reservation.ResId — NOT NULL
- MemberId (memberId) — int — Foreign key → Reservation.MemberId — NOT NULL
- Location (location) — varchar(300)
- XLoc (xLoc) — varchar(15)
- YLoc (yLoc) — varchar(15)
Member
- MemberId (memberId) — int — Primary key — NOT NULL
- UserId (userId) — varchar(30)
- Password (password) — varchar(30)
- CpName (cpName) — varchar(30)
- CpEmail (cpEmail) — varchar(50)
Period
- PeriodId (periodId) — int — Primary key — NOT NULL
- InfoId (infoId) — int — Foreign key → Information.InfoId — NOT NULL
- Period (period) — varchar(100)
- Time (time) — varchar(100)
Price
- PriceId (priceId) — int — Primary key — NOT NULL
- InfoId (infoId) — int — Foreign key → Information.InfoId — NOT NULL
- ResID (resId) — int — Foreign key → Reservation.ResId — NOT NULL
- MemberId (memberId) — int — Foreign key → Reservation.MemberId — NOT NULL
- Price (price) — varchar(100)
ResImage
- ResImageId (resImageId) — int — Primary key — NOT NULL
- ResId (resId) — int — Foreign key → Reservation.ResId — NOT NULL
- MemberId (memberId) — int — Foreign key → Reservation.MemberId — NOT NULL
- Image (image) — varchar(50)
ResInfoPeriod
- PeriodId (periodId) — int — Primary key — NOT NULL
- ResId (resId) — int — Foreign key → Reservation.ResId — NOT NULL
- MemberId (memberId) — int — Foreign key → Reservation.MemberId — NOT NULL
- Period (period) — varchar(100)
- Time (time) — varchar(100)
ResPeriod
- ResPeriodId (resPeriodId) — int — Primary key — NOT NULL
- ResID (resId) — int — Foreign key → Reservation.ResId — NOT NULL
- MemberId (memberId) — int — Foreign key → Reservation.MemberId — NOT NULL
- StartRes (startRes) — varchar(50)
- EndRes (endRes) — varchar(50)
Reservation
- ResId (resId) — int — Primary key — NOT NULL
- MemberId (memberId) — int — Foreign key → Member.MemberId — NOT NULL
- Title (title) — varchar(100)
- Contact (contact) — varchar(1000)
- ContactNum (contactNum) — varchar(15)
- Site (site) — varchar(50)