project

Tables (4)

Bag (CopyOfCopyOfUntitled2)

  • bagPK (Key) — int — Primary key — NOT NULL
  • memId (Key2) — varchar(50) — Foreign key → Member.memId — NOT NULL
  • winePK (Key3) — int — Foreign key → Wine.winePK — NOT NULL
  • wineCnt (Field3) — int

Member (Untitled)

  • memId (Key) — varchar(50) — Primary key — NOT NULL
  • memPw (Field) — varchar(50)
  • memName (Field2) — varchar(50)
  • memEmail (Field3) — varchar(50)
  • memPhone (Field4) — varchar(50)
  • memAddress (Field5) — varchar(200)

Subscription (CopyOfUntitled2)

  • subPK (Key) — int — Primary key — NOT NULL
  • memId (Key2) — varchar(50) — Foreign key → Member.memId — NOT NULL
  • subDate (Field) — varchar(50)
  • subTerm (Field3) — varchar(50)
  • startDate (Field4) — varchar(50)

Wine (CopyOfUntitled)

  • winePK (Key) — int — Primary key — NOT NULL
  • wineName (Field) — varchar(50)
  • winePrice (Field2) — varchar(50)
  • wineContent (Field4) — varchar(500)
  • wineCountry (Field5) — varchar(50)
  • wineCnt (Field6) — int
  • winePicture (Field7) — varchar(500)