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