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)