|
 |
Hit
Fields
| Field | Type | Comment |
| HitID | int(11) | |
| WebsiteID | int(11) unsigned | |
| UserID | int(11) unsigned | |
| PropertyID | int(11) unsigned | |
| BranchID | int(11) unsigned | |
| HitDate | date | |
| HitTime | time | |
| HitClass | varchar(8) | |
| HitData | longtext | |
Indexes
| Key | Seq | Column | Comment |
| PRIMARY | 1 | HitID | |
| WebsiteID | 1 | WebsiteID | |
| WebsiteID | 2 | HitDate | |
| WebsiteID | 3 | HitTime | |
| WebsiteID | 4 | HitClass | |
| WebsiteID | 5 | UserID | |
| PropertyID | 1 | PropertyID | |
| PropertyID | 2 | HitDate | |
| PropertyID | 3 | HitTime | |
| PropertyID | 4 | HitClass | |
| UserID | 1 | UserID | |
| UserID | 2 | HitDate | |
| UserID | 3 | HitTime | |
| UserID | 4 | HitClass | |
|
|
© Radical Solutions Limited 2005
|
|