| Columns |
| Name | Datatype | Null |
| username | char(8) | No |
| internet_site | varchar(255) | Yes |
| requid | char(16) | No |
| size | real | No |
| nfiles | int | No |
| ofrp | tinyint | No |
| custom_def | varchar(255) | Yes |
| products | varchar(255) | Yes |
| time | smalldatetime | No |
| id | numeric(18,0) | No |
| mode | char(1) | Yes |
|
Table Usage (MB) |
Distribution of Table Space |
|
Data |
6.59 |
Data |
84.04 % |
|
Indexes |
1.20 |
Indexes |
15.26 % |
|
Unused |
0.05 |
Unused |
0.70 % |
|
Total |
7.84 |
Number
of Rows |
26258 |
| Dependencies |
| Referencing Objects |
| Object Name | Object Type |
| dbo.checkofrpquota_sp | PROCEDURE |
| dbo.checkquota_sp | PROCEDURE |
| dbo.logrequest_sp | PROCEDURE |
| dbo.updaterequest_sp | PROCEDURE |
| dbo.request_log.request_log_ux | INDEX |
| dbo.request_log.request_log_ix | INDEX |
| Referenced Objects |
| Object Name | Object Type |
| DDL |
CREATE TABLE dbo.request_log
(
username char(8) NOT NULL,
internet_site varchar(255) NULL,
requid char(16) NOT NULL,
size real NOT NULL,
nfiles int NOT NULL,
ofrp tinyint NOT NULL,
custom_def varchar(255) NULL,
products varchar(255) NULL,
time smalldatetime NOT NULL,
id numeric(18,0) IDENTITY,
mode char(1) NULL
)
LOCK ALLPAGES
go
EXEC sp_primarykey 'dbo.request_log', id
go