[dbo].[INFOHIS]

Property	Value
Row Count	0
Created	3:44:35 PM Friday, June 13, 2003
Last Modified	3:44:35 PM Friday, June 13, 2003

Property

Value

Row Count

Created

3:44:35 PM Friday, June 13, 2003

Last Modified

3:44:35 PM Friday, June 13, 2003

	Name	Data Type	Max Length (Bytes)
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$ $Cluster Key INFOHIS_SK1: UNITID\UDOMID$	UDOMID	int	4
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$ $Cluster Key INFOHIS_SK1: UNITID\UDOMID$	UNITID	int	4
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$	ADOMID	int	4
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$	APID	int	4
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$	STTOTAL	int	4
	ACID	int	4
	STDATE	int	4
	STTIME	int	4
	ENDDATE	int	4
	ENDTIME	int	4
	ENDTOTAL	int	4
	APFLAG	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$ $Cluster Key INFOHIS_SK1: UNITID\UDOMID$

UDOMID

int

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$ $Cluster Key INFOHIS_SK1: UNITID\UDOMID$

UNITID

int

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$

ADOMID

int

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$

APID

int

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$

STTOTAL

int

ACID

int

STDATE

int

STTIME

int

ENDDATE

int

ENDTIME

int

ENDTOTAL

int

APFLAG

int

	Name	Columns	Unique
$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$	INFOHIS_PK	UNITID, APID, STTOTAL, UDOMID, ADOMID
$Cluster Key INFOHIS_SK1: UNITID\UDOMID$	INFOHIS_SK1	UNITID, UDOMID

Name

Columns

Unique

$Primary Key INFOHIS_PK: UNITID\APID\STTOTAL\UDOMID\ADOMID$

INFOHIS_PK

UNITID, APID, STTOTAL, UDOMID, ADOMID

$Cluster Key INFOHIS_SK1: UNITID\UDOMID$

INFOHIS_SK1

UNITID, UDOMID

SQL Script

CREATE TABLE [dbo].[INFOHIS]
(
[UDOMID] [int] NOT NULL,
[UNITID] [int] NOT NULL,
[ADOMID] [int] NOT NULL,
[APID] [int] NOT NULL,
[STTOTAL] [int] NOT NULL,
[ACID] [int] NULL,
[STDATE] [int] NULL,
[STTIME] [int] NULL,
[ENDDATE] [int] NULL,
[ENDTIME] [int] NULL,
[ENDTOTAL] [int] NULL,
[APFLAG] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[INFOHIS] ADD CONSTRAINT [INFOHIS_PK] PRIMARY KEY NONCLUSTERED ([UNITID], [APID], [STTOTAL], [UDOMID], [ADOMID]) ON [PRIMARY]
GO
CREATE CLUSTERED INDEX [INFOHIS_SK1] ON [dbo].[INFOHIS] ([UNITID], [UDOMID]) ON [PRIMARY]
GO