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)