| Columns |
| Name | Datatype | Null |
| id | numeric(5,0) | No |
| username | char(8) | Yes |
| password | varchar(16) | Yes |
| title | varchar(16) | Yes |
| name | varchar(32) | Yes |
| surname | varchar(32) | Yes |
| udfuser | char(1) | Yes |
| idauser | char(1) | Yes |
| site | varchar(80) | Yes |
| address1 | varchar(52) | Yes |
| address2 | varchar(52) | Yes |
| address3 | varchar(52) | Yes |
| city | varchar(52) | Yes |
| country | varchar(52) | Yes |
| machine | varchar(52) | Yes |
| varchar(52) | Yes | |
| phone | varchar(31) | Yes |
| fax | varchar(31) | Yes |
| quota | int | Yes |
| ofrp_quota | int | Yes |
| enabled | int | Yes |
| register_date | smalldatetime | Yes |
| enable_date | smalldatetime | Yes |
| last_login | smalldatetime | Yes |
| last_modified | smalldatetime | Yes |
|
Table Usage (MB) |
Distribution of Table Space |
|
Data |
0.95 |
Data |
97.21 % |
|
Indexes |
0.00 |
Indexes |
0.00 % |
|
Unused |
0.03 |
Unused |
2.79 % |
|
Total |
0.98 |
Number
of Rows |
3769 |
| Dependencies |
| Referencing Objects |
| Object Name | Object Type |
| dbo.changepassword_sp | PROCEDURE |
| dbo.checkofrpquota_sp | PROCEDURE |
| dbo.checkpassword_sp | PROCEDURE |
| dbo.checkquota_sp | PROCEDURE |
| dbo.checkudf_sp | PROCEDURE |
| dbo.registeruser_sp | PROCEDURE |
| dbo.retrieveuser_sp | PROCEDURE |
| dbo.updateuser_sp | PROCEDURE |
| Referenced Objects |
| Object Name | Object Type |
| DDL |
CREATE TABLE dbo.users
(
id numeric(5,0) IDENTITY,
username char(8) NULL,
password varchar(16) NULL,
title varchar(16) NULL,
name varchar(32) NULL,
surname varchar(32) NULL,
udfuser char(1) NULL,
idauser char(1) NULL,
site varchar(80) NULL,
address1 varchar(52) NULL,
address2 varchar(52) NULL,
address3 varchar(52) NULL,
city varchar(52) NULL,
country varchar(52) NULL,
machine varchar(52) NULL,
email varchar(52) NULL,
phone varchar(31) NULL,
fax varchar(31) NULL,
quota int NULL,
ofrp_quota int NULL,
enabled int NULL,
register_date smalldatetime NULL,
enable_date smalldatetime NULL,
last_login smalldatetime NULL,
last_modified smalldatetime NULL
)
LOCK DATAROWS
go