Table containing all the file/directory entries
FileServer
| Field Name | Field Type | Descriptions |
|
Name |
Text |
Contains the name of the File/Dir |
|
Type |
Number |
Type of file (File=1/Directory=2) |
|
ID |
AutoNumber |
The identification number of the File/Dir (Primary Key) |
|
Parent |
Number |
Id of the parent Node. All root level entries have this as 0. |
|
UserPermissions |
Number |
read, write, execute for the user RRWWXX |
|
WorldPermissions |
Number |
read, write, execute for the world RRWWXX |
|
UserID |
Number |
ID of the owner of the file (Foreign Key from UserData Table |
|
LockedBy |
Number |
ID of the user who has locked this file. 0 mean that no one has locked this file |
Table Containing the details of the users
UserData
|
Field Name |
Type |
Description |
|
UserName |
Text |
Name of the user |
|
Password |
Text |
Password of the user |
|
LoggingStatus |
Number |
Number of times the user has tried to login |
|
UserID |
Number |
ID of the user (Primary Key) |