PAYG

Tables (5)

GROUP (Untitled)

  • Key (GroupID) — int — Primary key — NOT NULL
  • Groupname — str
  • HTMLList (HTMLlistID)

HTMLList (Untitled3)

  • Key (GroupID) — int — Foreign key → GROUP.Key — NOT NULL
  • HTML (HTMLID1) — Foreign key → HistoryHTML.Key — NOT NULL
  • HTML (HTMLID2)
  • HTML (HTMLID3)
  • HTML (HTMLID4)

HistoryHTML (Untitled4)

  • Key (HTMLID) — Primary key — NOT NULL
  • pay1 (paidUser1)
  • pay1 (Userlist1)
  • pay2 (paidUser2)
  • pay2 (Userlist2)
  • pay3 (paidUser3)
  • pay3 (Userlist3)
  • totalopay (paidlist)
  • remittance

User (Untitled2)

  • Key1 (UserName) — str — Primary key — NOT NULL
  • Key2 (Phone.No) — str — Primary key
  • Field2
  • Key (GroupID) — int — Foreign key → User-GROUP relation.Key — NOT NULL

User-GROUP relation (Untitled5)

  • Key (GroupID) — int — Foreign key → GROUP.Key — NOT NULL
  • User1 (UserName1) — str — NOT NULL
  • User1 (Phone.No1) — str
  • User2 (UserName2)
  • User2 (Phone.No2)
  • User3 (UserName3) — NOT NULL
  • User3 (Phone.No3) — NOT NULL