Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceBranchVIPBusinessCount CCOS_DBOperation user table 2010-12-17 15:04:36.157
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BranchID nchar no 20 no (n/a) (n/a) Chinese_PRC_CI_AS
VIPBusinessCount int no 4 10 0 yes (n/a) (n/a) NULL
MendDelayCount int no 4 10 0 yes (n/a) (n/a) NULL
MendVerifyCount int no 4 10 0 yes (n/a) (n/a) NULL
MPCVIPBusinessCount int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceBranchVIPBusinessCount clustered, unique, primary key located on PRIMARY BranchID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column MPCVIPBusinessCount DF__Reference__MPCVI__049AA3C2 (n/a) (n/a) (n/a) (n/a) ((30))
DEFAULT on column MendDelayCount DF_ReferenceBranchVIPBusinessCount_MendDelayCount (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column MendVerifyCount DF_ReferenceBranchVIPBusinessCount_MendVerifyCount (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column VIPBusinessCount DF_ReferenceBranchVIPBusinessCount_VIPBusinessCount (n/a) (n/a) (n/a) (n/a) ((0))
PRIMARY KEY (clustered) PK_ReferenceBranchVIPBusinessCount (n/a) (n/a) (n/a) (n/a) BranchID
没有外键引用表 '[CCOS].[ReferenceBranchVIPBusinessCount]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceBranchVIPBusinessCount]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferneceApplyID CCOS_DBOperation user table 2010-10-26 11:10:16.263
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ApplyCode int no 4 10 0 yes (n/a) (n/a) NULL
ApplyCount int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
对象 '[CCOS].[ReferneceApplyID ]' 没有任何索引,或者您没有所需的权限。
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ApplyCode DF_TApplyNumber_ApplyCode (n/a) (n/a) (n/a) (n/a) ((65))
DEFAULT on column ApplyCount DF_TApplyNumber_ApplyCount (n/a) (n/a) (n/a) (n/a) ((0))
没有外键引用表 '[CCOS].[ReferneceApplyID ]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferneceApplyID ]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCardSalary CCOS_DBOperation user table 2010-12-01 14:36:01.403
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
CardType nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
NationalityFlag bit no 1 yes (n/a) (n/a) NULL
AutoIssuanceFlag nvarchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
Salary money no 8 19 4 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCardSalary clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceCardSalary (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceCardSalary]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCardSalary]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
CustomerContactTaskDetail CCOS_DBOperation user table 2011-02-22 11:06:57.477
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CustomerContactTaskId int no 4 10 0 no (n/a) (n/a) NULL
BusinessId varchar no 20 yes no yes Chinese_PRC_CI_AS
CPCTaskId int no 4 10 0 no (n/a) (n/a) NULL
UserId varchar no 16 yes no yes Chinese_PRC_CI_AS
BranchId varchar no 16 yes no yes Chinese_PRC_CI_AS
Status int no 4 10 0 yes (n/a) (n/a) NULL
EntryDatetime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
CustomerContactTaskId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_CustomerContactTaskDetail clustered, unique, primary key located on PRIMARY CustomerContactTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column EntryDatetime DF_CustomerContactTaskDetail_EntryDatetime (n/a) (n/a) (n/a) (n/a) (getdate())
DEFAULT on column Status DF_CustomerContactTaskDetail_Status (n/a) (n/a) (n/a) (n/a) ((1))
PRIMARY KEY (clustered) PK_CustomerContactTaskDetail (n/a) (n/a) (n/a) (n/a) CustomerContactTaskId
没有外键引用表 '[CCOS].[CustomerContactTaskDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[CustomerContactTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceMainCardBinCardType CCOS_DBOperation user table 2010-12-01 15:09:35.380
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
CardType nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
CardName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
MainCardBin nvarchar no 30 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsActive int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceMainCardBinCardType clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceMainCardBinCardType (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceMainCardBinCardType]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceMainCardBinCardType]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
sysdiagrams dbo user table 2010-11-10 17:36:17.350
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
name sysname no 256 no (n/a) (n/a) Chinese_PRC_CI_AS
principal_id int no 4 10 0 no (n/a) (n/a) NULL
diagram_id int no 4 10 0 no (n/a) (n/a) NULL
version int no 4 10 0 yes (n/a) (n/a) NULL
definition varbinary no -1 yes no yes NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
diagram_id 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK__sysdiagrams__09A971A2 clustered, unique, primary key located on PRIMARY diagram_id
UK_principal_name nonclustered, unique, unique key located on PRIMARY principal_id, name
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK__sysdiagrams__09A971A2 (n/a) (n/a) (n/a) (n/a) diagram_id
UNIQUE (non-clustered) UK_principal_name (n/a) (n/a) (n/a) (n/a) principal_id, name
没有外键引用表 '[dbo].[sysdiagrams]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[dbo].[sysdiagrams]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
TemporaryRecordDetail CCOS_DBOperation user table 2010-12-20 18:07:24.697
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ID int no 4 10 0 no (n/a) (n/a) NULL
BusinessId varchar no 20 yes no yes Chinese_PRC_CI_AS
InspectId varchar no 50 yes no yes Chinese_PRC_CI_AS
InspectResult varchar no 5 yes no yes Chinese_PRC_CI_AS
InspectType varchar no 5 yes no yes Chinese_PRC_CI_AS
Comments varchar no 255 yes no yes Chinese_PRC_CI_AS
ColumnName varchar no 255 yes no yes Chinese_PRC_CI_AS
ColumnValue varchar no 500 yes no yes Chinese_PRC_CI_AS
CreateDate datetime no 8 yes (n/a) (n/a) NULL
Status int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ID 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_TemporaryRecordDetail clustered, unique, primary key located on PRIMARY ID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column CreateDate DF_TemporaryRecordDetail_CreateDate (n/a) (n/a) (n/a) (n/a) (getdate())
DEFAULT on column Status DF_TemporaryRecordDetail_Status (n/a) (n/a) (n/a) (n/a) ((1))
PRIMARY KEY (clustered) PK_TemporaryRecordDetail (n/a) (n/a) (n/a) (n/a) ID
没有外键引用表 '[CCOS].[TemporaryRecordDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[TemporaryRecordDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferencePhoneAreaCode CCOS_DBOperation user table 2011-01-21 16:47:33.773
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
ProvinceName nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
AreaName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
AreaCode varchar no 20 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferencePhoneAreaCode clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferencePhoneAreaCode (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferencePhoneAreaCode]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferencePhoneAreaCode]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceBranchMarketer CCOS_DBOperation user table 2010-12-01 15:12:27.690
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
City nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
CredentialNO nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
CredentialPeriod datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceBranchMarketer clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceBranchMarketer (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceBranchMarketer]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceBranchMarketer]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferencePostcode CCOS_DBOperation user table 2011-01-21 16:47:48.507
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
CityName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
PostCode varchar no 20 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferencePostcode clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferencePostcode (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferencePostcode]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferencePostcode]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCPCUserCallerId CCOS_DBOperation user table 2010-12-01 15:13:43.263
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
CPCUser nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
CallerId nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCPCUserCallerId clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceCPCUserCallerId (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceCPCUserCallerId]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCPCUserCallerId]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCityCorporateCard CCOS_DBOperation user table 2011-02-22 11:33:57.000
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CityCode nvarchar no 16 no (n/a) (n/a) Chinese_PRC_CI_AS
BranchCode nvarchar no 16 no (n/a) (n/a) Chinese_PRC_CI_AS
CardCode nvarchar no 16 no (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCityCorporateCard clustered, unique, primary key located on PRIMARY CityCode, BranchCode
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceCityCorporateCard (n/a) (n/a) (n/a) (n/a) CityCode, BranchCode
没有外键引用表 '[CCOS].[ReferenceCityCorporateCard]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCityCorporateCard]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
CCOSBusinessOtherFields CCOS_DBOperation user table 2011-01-24 18:09:31.440
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
DownloadCount int no 4 10 0 yes (n/a) (n/a) NULL
UploadStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
MendScanCount int no 4 10 0 yes (n/a) (n/a) NULL
MendAlreadyCount int no 4 10 0 yes (n/a) (n/a) NULL
CustomerContactCount int no 4 10 0 yes (n/a) (n/a) NULL
FtpSendCount int no 4 10 0 yes (n/a) (n/a) NULL
CCInteractiveDateTime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_CCOS.CCOSBusinessOtherFields clustered, unique, primary key located on PRIMARY BusinessId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column DownloadCount DF_CCOS.CCOSBusinessOtherFields_DownloadCount (n/a) (n/a) (n/a) (n/a) ((1))
DEFAULT on column CustomerContactCount DF_CCOSBusinessOtherFields_CustomerContactCount (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column FtpSendCount DF_CCOSBusinessOtherFields_FtpSendCount (n/a) (n/a) (n/a) (n/a) ((1))
DEFAULT on column MendAlreadyCount DF_CCOSBusinessOtherFields_MendAlreadyCount (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column MendScanCount DF_CCOSBusinessOtherFields_MendScanCount (n/a) (n/a) (n/a) (n/a) ((0))
PRIMARY KEY (clustered) PK_CCOS.CCOSBusinessOtherFields (n/a) (n/a) (n/a) (n/a) BusinessId
没有外键引用表 '[CCOS].[CCOSBusinessOtherFields]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[CCOSBusinessOtherFields]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
DataMatchTaskDetail CCOS_DBOperation user table 2010-12-24 15:14:04.873
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
MatchTaskId int no 4 10 0 no (n/a) (n/a) NULL
CPCTaskId int no 4 10 0 no (n/a) (n/a) NULL
MatchStatus varchar no 5 no no no Chinese_PRC_CI_AS
MatchComment nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
Summary nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
OutputFieldName varchar no 50 yes no yes Chinese_PRC_CI_AS
ErrorCode varchar no 5 yes no yes Chinese_PRC_CI_AS
ToPost varchar no 5 yes no yes Chinese_PRC_CI_AS
Status varchar no 5 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
MatchTaskId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_DataMatchTaskDetail clustered, unique, primary key located on PRIMARY MatchTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_DataMatchTaskDetail (n/a) (n/a) (n/a) (n/a) MatchTaskId
FOREIGN KEY WorkflowTaskData_DataMatchTaskDetail_FK1 No Action No Action Enabled Is_For_Replication CPCTaskId
REFERENCES CCOS_BusinessDB.CCOS.WorkflowTaskData (CPCTaskId)
Table is referenced by foreign key
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CCOS_BusinessDB.CCOS.DataMatchItem: FK_DataMatchTaskDetail_DataMatchItem
所有具有架构绑定的视图均未引用表 '[CCOS].[DataMatchTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ImgZipCompressSendErrorCount CCOS_DBOperation user table 2011-03-22 09:57:07.590
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ZipCompressName varchar no 50 no yes no Chinese_PRC_CI_AS
FtpSendCount int no 4 10 0 no (n/a) (n/a) NULL
ErrorDate datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ImgZipCompressSendErrorCount clustered, unique, primary key located on PRIMARY ZipCompressName
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ErrorDate DF_ImgZipCompressSendErrorCount_ErrorDate (n/a) (n/a) (n/a) (n/a) (getdate())
DEFAULT on column FtpSendCount DF_ImgZipCompressSendErrorCount_FtpSendCount (n/a) (n/a) (n/a) (n/a) ((1))
PRIMARY KEY (clustered) PK_ImgZipCompressSendErrorCount (n/a) (n/a) (n/a) (n/a) ZipCompressName
没有外键引用表 '[CCOS].[ImgZipCompressSendErrorCount]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ImgZipCompressSendErrorCount]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
CCOSMendBusiness CCOS_DBOperation user table 2010-12-30 14:35:50.500
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
OriginalBusinessId varchar no 20 no no no Chinese_PRC_CI_AS
ApplyID varchar no 10 yes no yes Chinese_PRC_CI_AS
BusinessStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
BusinessType varchar no 5 yes no yes Chinese_PRC_CI_AS
VoucherType varchar no 5 yes no yes Chinese_PRC_CI_AS
TransactionDate datetime no 8 yes (n/a) (n/a) NULL
InitBranchId varchar no 4 yes no yes Chinese_PRC_CI_AS
InitUserId varchar no 8 yes no yes Chinese_PRC_CI_AS
AuthUserId varchar no 8 yes no yes Chinese_PRC_CI_AS
BusinessStatusUpdateDate datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_CCOSMendBusiness clustered, unique, primary key located on PRIMARY BusinessId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_CCOSMendBusiness (n/a) (n/a) (n/a) (n/a) BusinessId
没有外键引用表 '[CCOS].[CCOSMendBusiness]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[CCOSMendBusiness]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
DictionaryCategory CCOS_DBOperation user table 2010-11-01 14:53:07.240
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CategoryId int no 4 10 0 no (n/a) (n/a) NULL
CategoryName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsValid bit no 1 yes (n/a) (n/a) NULL
IsCached bit no 1 yes (n/a) (n/a) NULL
RelationField varchar no 75 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DictionaryCategory2_PK clustered, unique, primary key located on PRIMARY CategoryId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) DictionaryCategory2_PK (n/a) (n/a) (n/a) (n/a) CategoryId
Table is referenced by foreign key
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CCOS_BusinessDB.CCOS.DictionaryItem: FK_DictionaryItem_DictionaryCategory
所有具有架构绑定的视图均未引用表 '[CCOS].[DictionaryCategory]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
DictionaryItem CCOS_DBOperation user table 2010-11-01 17:44:48.250
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CategoryId int no 4 10 0 no (n/a) (n/a) NULL
Code varchar no 16 no no no Chinese_PRC_CI_AS
ShortDescription nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
LongDescription nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
LocaleCode varchar no 4 yes no yes Chinese_PRC_CI_AS
SortOrder smallint no 2 5 0 yes (n/a) (n/a) NULL
Status varchar no 1 yes no yes Chinese_PRC_CI_AS
GUID nvarchar no 100 no (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DictionaryItem_UNIQUE nonclustered, unique, unique key located on PRIMARY CategoryId, Code, Status
PK_DictionaryItem clustered, unique, primary key located on PRIMARY GUID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column GUID DF_DictionaryItem_GUID (n/a) (n/a) (n/a) (n/a) (newid())
UNIQUE (non-clustered) DictionaryItem_UNIQUE (n/a) (n/a) (n/a) (n/a) CategoryId, Code, Status
FOREIGN KEY FK_DictionaryItem_DictionaryCategory No Action No Action Enabled Is_For_Replication CategoryId
REFERENCES CCOS_BusinessDB.CCOS.DictionaryCategory (CategoryId)
PRIMARY KEY (clustered) PK_DictionaryItem (n/a) (n/a) (n/a) (n/a) GUID
没有外键引用表 '[CCOS].[DictionaryItem]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[DictionaryItem]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceGradeABuildingList CCOS_DBOperation user table 2011-01-26 16:40:17.457
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ID int no 4 10 0 no (n/a) (n/a) NULL
CityName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
BuildingName nvarchar no 1000 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ID 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceGradeABuildingList nonclustered, unique, primary key located on PRIMARY ID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (non-clustered) PK_ReferenceGradeABuildingList (n/a) (n/a) (n/a) (n/a) ID
没有外键引用表 '[CCOS].[ReferenceGradeABuildingList]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceGradeABuildingList]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
DataEntryTaskDetail CCOS_DBOperation user table 2010-11-11 14:47:07.583
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
DataEntryTaskId int no 4 10 0 no (n/a) (n/a) NULL
CPCTaskId int no 4 10 0 no (n/a) (n/a) NULL
VoucherType varchar no 5 yes no yes Chinese_PRC_CI_AS
ElementField varchar no 50 yes no yes Chinese_PRC_CI_AS
ElementType varchar no 20 yes no yes Chinese_PRC_CI_AS
ElementValue nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
DataEntryType varchar no 5 yes no yes Chinese_PRC_CI_AS
AuthorizeStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
VoucherIndex tinyint no 1 3 0 yes (n/a) (n/a) NULL
ValidateCheck varchar no 5 yes no yes Chinese_PRC_CI_AS
EntryDatetime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_DataEntryTaskDetail clustered, unique, primary key located on PRIMARY DataEntryTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column EntryDatetime DF_DataEntryTaskDetail_EntryDatetime (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_DataEntryTaskDetail (n/a) (n/a) (n/a) (n/a) DataEntryTaskId
没有外键引用表 '[CCOS].[DataEntryTaskDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[DataEntryTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ErrorBusinessDataDetail CCOS_DBOperation user table 2011-02-28 17:00:04.773
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
ApplyId varchar no 10 yes no yes Chinese_PRC_CI_AS
CardCode nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
CardBranchID nvarchar no 8 yes (n/a) (n/a) Chinese_PRC_CI_AS
ColumnsName nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
ErrorDiscription nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
UpdateDate datetime no 8 yes (n/a) (n/a) NULL
IsSPTCard varchar no 2 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ErrorBusinessDataDetail clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column UpdateDate DF_ErrorBusinessDataDetail_UpdateDate (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_ErrorBusinessDataDetail (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ErrorBusinessDataDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ErrorBusinessDataDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCardCodePromotionId CCOS_DBOperation user table 2010-12-31 17:56:42.800
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CardCode nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
PromotionId nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
StartDate datetime no 8 yes (n/a) (n/a) NULL
EndDate datetime no 8 yes (n/a) (n/a) NULL
Status varchar no 1 yes no yes Chinese_PRC_CI_AS
GUID nvarchar no 100 no (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCardCodePromotionId_1 clustered, unique, primary key located on PRIMARY GUID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column GUID DF_ReferenceCardCodePromotionId_GUID (n/a) (n/a) (n/a) (n/a) (newid())
PRIMARY KEY (clustered) PK_ReferenceCardCodePromotionId_1 (n/a) (n/a) (n/a) (n/a) GUID
没有外键引用表 '[CCOS].[ReferenceCardCodePromotionId]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCardCodePromotionId]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceSocialSecurityList CCOS_DBOperation user table 2011-01-26 16:41:12.170
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ID int no 4 10 0 no (n/a) (n/a) NULL
CityName nvarchar no 510 yes (n/a) (n/a) Chinese_PRC_CI_AS
ItemRequire nvarchar no 4000 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ID 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceSocialSecurityList nonclustered, unique, primary key located on PRIMARY ID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (non-clustered) PK_ReferenceSocialSecurityList (n/a) (n/a) (n/a) (n/a) ID
没有外键引用表 '[CCOS].[ReferenceSocialSecurityList]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceSocialSecurityList]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ErrorTaskDetail CCOS_DBOperation user table 2010-11-12 10:27:27.833
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ErrorTaskId int no 4 10 0 no (n/a) (n/a) NULL
CPCTaskId int no 4 10 0 yes (n/a) (n/a) NULL
ErrorTypeCode varchar no 5 yes no yes Chinese_PRC_CI_AS
Comment nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
ErrorStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
ErrorLevel int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ErrorTaskId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ErrorTaskDetail_PK clustered, unique, primary key located on PRIMARY ErrorTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ErrorLevel DF_ErrorTaskDetail_ErrorLevel (n/a) (n/a) (n/a) (n/a) ((0))
PRIMARY KEY (clustered) ErrorTaskDetail_PK (n/a) (n/a) (n/a) (n/a) ErrorTaskId
没有外键引用表 '[CCOS].[ErrorTaskDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ErrorTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceUndergraduateCollegeList CCOS_DBOperation user table 2011-01-26 16:42:16.050
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ID int no 4 10 0 no (n/a) (n/a) NULL
CityName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
CollegeName nvarchar no 1000 yes (n/a) (n/a) Chinese_PRC_CI_AS
CollegeCategory nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ID 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceUndergraduateCollegeList nonclustered, unique, primary key located on PRIMARY ID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (non-clustered) PK_ReferenceUndergraduateCollegeList (n/a) (n/a) (n/a) (n/a) ID
没有外键引用表 '[CCOS].[ReferenceUndergraduateCollegeList]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceUndergraduateCollegeList]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceSendCardAreaList CCOS_DBOperation user table 2011-01-26 16:42:51.163
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ID int no 4 10 0 no (n/a) (n/a) NULL
CityName nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
AllChannelsArea nvarchar no 4000 yes (n/a) (n/a) Chinese_PRC_CI_AS
ExistCustomerArea nvarchar no 4000 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ID 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceSendCardAreaList nonclustered, unique, primary key located on PRIMARY ID
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (non-clustered) PK_ReferenceSendCardAreaList (n/a) (n/a) (n/a) (n/a) ID
没有外键引用表 '[CCOS].[ReferenceSendCardAreaList]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceSendCardAreaList]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
IHGMemo CCOS_DBOperation user table 2011-01-27 14:06:40.703
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
Room varchar no 35 yes no yes Chinese_PRC_CI_AS
Unit varchar no 35 yes no yes Chinese_PRC_CI_AS
Building varchar no 35 yes no yes Chinese_PRC_CI_AS
Village varchar no 35 yes no yes Chinese_PRC_CI_AS
Lane varchar no 35 yes no yes Chinese_PRC_CI_AS
Road varchar no 35 yes no yes Chinese_PRC_CI_AS
District varchar no 35 yes no yes Chinese_PRC_CI_AS
City varchar no 35 yes no yes Chinese_PRC_CI_AS
PostingCode varchar no 6 yes no yes Chinese_PRC_CI_AS
SPTRoom varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTUnit varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTBuilding varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTVillage varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTLane varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTRoad varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTDistrict varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTCity varchar no 35 yes no yes Chinese_PRC_CI_AS
SPTPostingCode varchar no 6 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_IHGMemo clustered, unique, primary key located on PRIMARY BusinessId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_IHGMemo (n/a) (n/a) (n/a) (n/a) BusinessId
没有外键引用表 '[CCOS].[IHGMemo]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[IHGMemo]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCorporateCardCompany CCOS_DBOperation user table 2011-01-11 21:06:38.677
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
BranchCode nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyCode nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyName nvarchar no 510 yes (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCorporateCardCompany clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceCorporateCardCompany (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceCorporateCardCompany]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCorporateCardCompany]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceErrorInfo CCOS_DBOperation user table 2010-11-05 10:09:22.593
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessType varchar no 5 no no no Chinese_PRC_CI_AS
ErrorCode varchar no 10 no no no Chinese_PRC_CI_AS
OperationCode varchar no 10 no no no Chinese_PRC_CI_AS
OperationFlag bit no 1 no (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceErrorInfo clustered, unique, primary key located on PRIMARY BusinessType, ErrorCode, OperationCode
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceErrorInfo (n/a) (n/a) (n/a) (n/a) BusinessType, ErrorCode, OperationCode
没有外键引用表 '[CCOS].[ReferenceErrorInfo]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceErrorInfo]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
CCOSFlowTrendTaskDetail CCOS_DBOperation user table 2011-03-09 09:52:07.180
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
FlowTrendTaskId int no 4 10 0 no (n/a) (n/a) NULL
BusinessId varchar no 20 yes no yes Chinese_PRC_CI_AS
CPCTaskId int no 4 10 0 yes (n/a) (n/a) NULL
UserId varchar no 16 yes no yes Chinese_PRC_CI_AS
BranchId varchar no 16 yes no yes Chinese_PRC_CI_AS
PostName nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
FlowTrendId int no 4 10 0 yes (n/a) (n/a) NULL
EntryDate datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
FlowTrendTaskId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_CCOSFlowTrendTaskDetail clustered, unique, primary key located on PRIMARY FlowTrendTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column EntryDate DF_CCOSFlowTrendTaskDetail_EntryDate (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_CCOSFlowTrendTaskDetail (n/a) (n/a) (n/a) (n/a) FlowTrendTaskId
没有外键引用表 '[CCOS].[CCOSFlowTrendTaskDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[CCOSFlowTrendTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ManualInspectTaskDetail CCOS_DBOperation user table 2011-01-12 19:54:53.850
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
ManualInspectTaskId int no 4 10 0 no (n/a) (n/a) NULL
BusinessId varchar no 20 yes no yes Chinese_PRC_CI_AS
CPCTaskId int no 4 10 0 no (n/a) (n/a) NULL
InspectId varchar no 50 yes no yes Chinese_PRC_CI_AS
ItemName varchar no 50 yes no yes Chinese_PRC_CI_AS
ItemDesc varchar no 2048 yes no yes Chinese_PRC_CI_AS
InspectResult varchar no 5 yes no yes Chinese_PRC_CI_AS
InspectType varchar no 5 yes no yes Chinese_PRC_CI_AS
Comments varchar no 255 yes no yes Chinese_PRC_CI_AS
InspectDatetime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
ManualInspectTaskId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ManualInspectTaskDetail clustered, unique, primary key located on PRIMARY ManualInspectTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column InspectDatetime DF_ManualInspectTaskDetail_InspectDatetime (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_ManualInspectTaskDetail (n/a) (n/a) (n/a) (n/a) ManualInspectTaskId
没有外键引用表 '[CCOS].[ManualInspectTaskDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ManualInspectTaskDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCPCUserCallDetail CCOS_DBOperation user table 2011-02-12 18:27:06.827
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
ExtNumber nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
OppositePhone nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
CPCUserId nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
SeatId nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
RecordingStartTime datetime no 8 yes (n/a) (n/a) NULL
RecordingEndTime datetime no 8 yes (n/a) (n/a) NULL
CallsDuration varchar no 5 yes no yes Chinese_PRC_CI_AS
CallsType varchar no 1 yes no yes Chinese_PRC_CI_AS
DataSaveTime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCPCUserCallDetail clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column DataSaveTime DF_ReferenceCPCUserCallDetail_DataSaveTime (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_ReferenceCPCUserCallDetail (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceCPCUserCallDetail]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCPCUserCallDetail]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
CCOSBusiness CCOS_DBOperation user table 2011-04-09 16:59:19.790
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
ApplyID varchar no 10 yes no yes Chinese_PRC_CI_AS
BusinessStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
BusinessType varchar no 5 yes no yes Chinese_PRC_CI_AS
VoucherType varchar no 6 yes no yes Chinese_PRC_CI_AS
TransactionDate datetime no 8 yes (n/a) (n/a) NULL
InitBranchId varchar no 4 yes no yes Chinese_PRC_CI_AS
InitUserId varchar no 8 yes no yes Chinese_PRC_CI_AS
AuthUserId varchar no 8 yes no yes Chinese_PRC_CI_AS
IsIdentificationCard varchar no 2 yes no yes Chinese_PRC_CI_AS
IsVip varchar no 2 yes no yes Chinese_PRC_CI_AS
CardTitle nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
CardCode varchar no 8 yes no yes Chinese_PRC_CI_AS
MemCardName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
MemCardNO nvarchar no 32 yes (n/a) (n/a) Chinese_PRC_CI_AS
ApplicantName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
ApplicantEName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
CredentialType varchar no 8 yes no yes Chinese_PRC_CI_AS
CredentialNO nvarchar no 38 yes (n/a) (n/a) Chinese_PRC_CI_AS
CredentialPeriod datetime no 8 yes (n/a) (n/a) NULL
ExpectedCreditQuantity money no 8 19 4 yes (n/a) (n/a) NULL
CardholderNumber varchar no 10 yes no yes Chinese_PRC_CI_AS
Nationality nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
Gender varchar no 8 yes no yes Chinese_PRC_CI_AS
Birthday datetime no 8 yes (n/a) (n/a) NULL
MaritalStatus varchar no 8 yes no yes Chinese_PRC_CI_AS
Education varchar no 8 yes no yes Chinese_PRC_CI_AS
ResidentialStatus varchar no 8 yes no yes Chinese_PRC_CI_AS
ResidentialAddress1 nvarchar no 80 yes (n/a) (n/a) Chinese_PRC_CI_AS
ResidentialAddress2 nvarchar no 80 yes (n/a) (n/a) Chinese_PRC_CI_AS
ResidentialAddress3 nvarchar no 320 yes (n/a) (n/a) Chinese_PRC_CI_AS
ZipCode varchar no 6 yes no yes Chinese_PRC_CI_AS
Residence nvarchar no 20 yes (n/a) (n/a) Chinese_PRC_CI_AS
HomePhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
HomePhone nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
Mobile varchar no 12 yes no yes Chinese_PRC_CI_AS
eMail nvarchar no 80 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsDepositUser nchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsOrientalCardUser nchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsCreditUser nchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
Company nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
Department nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
Position nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyIndustry nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyAddress1 nvarchar no 80 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyAddress2 nvarchar no 80 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyAddress3 nvarchar no 320 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyZipCode varchar no 6 yes no yes Chinese_PRC_CI_AS
CompanyNature varchar no 8 yes no yes Chinese_PRC_CI_AS
Shares nvarchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyPhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
CompanyPhoneNum nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyPhoneExtNum nvarchar no 12 yes (n/a) (n/a) Chinese_PRC_CI_AS
SalaryAT money no 8 19 4 yes (n/a) (n/a) NULL
WorkLengthY varchar no 4 yes no yes Chinese_PRC_CI_AS
WorkLengthM varchar no 2 yes no yes Chinese_PRC_CI_AS
TWorkLengthY varchar no 4 yes no yes Chinese_PRC_CI_AS
TWorkLengthM varchar no 2 yes no yes Chinese_PRC_CI_AS
IMDContactName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
IMDContactCompany nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
IMDContactRelation nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
IMDContactAddress nvarchar no 120 yes (n/a) (n/a) Chinese_PRC_CI_AS
IMDContactPhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
IMDContactPhone nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
IMDContactMobile nvarchar no 24 yes (n/a) (n/a) Chinese_PRC_CI_AS
OthContactName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
OthContactRelation nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
OthContactCompany nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
OthContactPhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
OthContactPhone nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
OthContactMobile nvarchar no 24 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardMemberNO nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardEName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardNationality nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardGender varchar no 8 yes no yes Chinese_PRC_CI_AS
SPTCardBirthday datetime no 8 yes (n/a) (n/a) NULL
SPTCardCredentialType varchar no 8 yes no yes Chinese_PRC_CI_AS
SPTCardCredentialNO nvarchar no 38 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardCredentialPeriod datetime no 8 yes (n/a) (n/a) NULL
SPTCardRelation nvarchar no 16 yes (n/a) (n/a) Chinese_PRC_CI_AS
SamePhoneFlag nvarchar no 2 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardHomePhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
SPTCardHomePhone nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardCompany nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardPhoneAreaCode varchar no 4 yes no yes Chinese_PRC_CI_AS
SPTCardPhone nvarchar no 34 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardMobile nvarchar no 24 yes (n/a) (n/a) Chinese_PRC_CI_AS
BillPostType varchar no 4 yes no yes Chinese_PRC_CI_AS
BillPostAddress varchar no 4 yes no yes Chinese_PRC_CI_AS
CardReceiveType varchar no 4 yes no yes Chinese_PRC_CI_AS
CardPostAddress varchar no 4 yes no yes Chinese_PRC_CI_AS
CardReceiveBranch varchar no 4 yes no yes Chinese_PRC_CI_AS
AppInsurance varchar no 1 yes no yes Chinese_PRC_CI_AS
AcceptMailFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
AcceptPhoneFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
AutoIssuanceFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
NTRepayAccount nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
NTRepayFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
USDRepayAccount nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
USDRepayFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
CombRepayFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
NTExchangeRepayFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
SameNTRepayAccountFlag varchar no 1 yes no yes Chinese_PRC_CI_AS
USDRepaySelect varchar no 1 yes no yes Chinese_PRC_CI_AS
NTExchangeRepaySelect varchar no 1 yes no yes Chinese_PRC_CI_AS
CombRepaySelect varchar no 1 yes no yes Chinese_PRC_CI_AS
MarketerName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
MarketerPhone nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
DocumentSource varchar no 8 yes no yes Chinese_PRC_CI_AS
CheckedIDCard varchar no 1 yes no yes Chinese_PRC_CI_AS
VisitedHome varchar no 1 yes no yes Chinese_PRC_CI_AS
SeenSign varchar no 1 yes no yes Chinese_PRC_CI_AS
VisitedCompany varchar no 1 yes no yes Chinese_PRC_CI_AS
CheckedAppJob varchar no 1 yes no yes Chinese_PRC_CI_AS
MarketerNote nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
ManagerNote nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
MarketerDep nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
MarketerCode varchar no 30 yes no yes Chinese_PRC_CI_AS
PromotionID varchar no 8 yes no yes Chinese_PRC_CI_AS
CityCode varchar no 8 yes no yes Chinese_PRC_CI_AS
ChannelCode varchar no 8 yes no yes Chinese_PRC_CI_AS
DocumentCategory varchar no 8 yes no yes Chinese_PRC_CI_AS
CompanyCode nvarchar no 40 yes (n/a) (n/a) Chinese_PRC_CI_AS
SPTCardCount int no 4 10 0 yes (n/a) (n/a) NULL
SPTCardFlag int no 4 10 0 yes (n/a) (n/a) NULL
CardBranchID varchar no 4 yes no yes Chinese_PRC_CI_AS
MainCardNO nvarchar no 38 yes (n/a) (n/a) Chinese_PRC_CI_AS
IsPhotoCard varchar no 1 yes no yes Chinese_PRC_CI_AS
IsEmployeeCard varchar no 1 yes no yes Chinese_PRC_CI_AS
IsSPTCardImage varchar no 1 yes no yes Chinese_PRC_CI_AS
IsDoubleFace varchar no 1 yes no yes Chinese_PRC_CI_AS
BusinessStatusUpdateDate datetime no 8 yes (n/a) (n/a) NULL
OnlineCheckResult nvarchar no 10 yes (n/a) (n/a) Chinese_PRC_CI_AS
PositionCode varchar no 20 yes no yes Chinese_PRC_CI_AS
PresentCardCode varchar no 8 yes no yes Chinese_PRC_CI_AS
PutLetterType char no 1 yes no yes Chinese_PRC_CI_AS
IsAcceptCreditQuantity char no 1 yes no yes Chinese_PRC_CI_AS
CredentialAddress1 varchar no 40 yes no yes Chinese_PRC_CI_AS
CredentialAddress2 varchar no 40 yes no yes Chinese_PRC_CI_AS
CredentialAddress3 varchar no 160 yes no yes Chinese_PRC_CI_AS
CredentialAddressZipCode varchar no 6 yes no yes Chinese_PRC_CI_AS
CredentialBelong varchar no 40 yes no yes Chinese_PRC_CI_AS
KeyFieldModifyResult char no 6 yes no yes Chinese_PRC_CI_AS
ApplyCheckResult char no 1 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IX_CCOSBusiness_ApplyId nonclustered, unique located on PRIMARY ApplyID
PK_CCOSBusiness clustered, unique, primary key located on PRIMARY BusinessId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ApplyCheckResult DF_CCOSBusiness_ApplyCheckResult (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column KeyFieldModifyResult DF_CCOSBusiness_KeyFieldModifyResult (n/a) (n/a) (n/a) (n/a) ('NNNNNN')
PRIMARY KEY (clustered) PK_CCOSBusiness (n/a) (n/a) (n/a) (n/a) BusinessId
没有外键引用表 '[CCOS].[CCOSBusiness]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[CCOSBusiness]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
WorkflowData CCOS_DBOperation user table 2010-11-10 13:59:01.223
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CPCInstanceId int no 4 10 0 no (n/a) (n/a) NULL
WorkflowInstanceId varchar no 60 yes no yes Chinese_PRC_CI_AS
ParentInstanceId varchar no 60 yes no yes Chinese_PRC_CI_AS
WorkflowId varchar no 300 yes no yes Chinese_PRC_CI_AS
ImageId varchar no 60 yes no yes Chinese_PRC_CI_AS
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
BusinessType varchar no 5 yes yes yes Chinese_PRC_CI_AS
BusinessStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
BusinessDateTime datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
CPCInstanceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WorkflowData_PK clustered, unique, primary key located on PRIMARY CPCInstanceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column BusinessDateTime DF__WorkflowD__Busin__6A30C649 (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) WorkflowData_PK (n/a) (n/a) (n/a) (n/a) CPCInstanceId
没有外键引用表 '[CCOS].[WorkflowData]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[WorkflowData]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
MobileBusinessBranchData CCOS_DBOperation user table 2011-04-15 13:57:37.083
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
ApplyID varchar no 10 yes no yes Chinese_PRC_CI_AS
ApplicantName nvarchar no 60 yes (n/a) (n/a) Chinese_PRC_CI_AS
Gender varchar no 8 yes no yes Chinese_PRC_CI_AS
Birthday datetime no 8 yes (n/a) (n/a) NULL
Mobile varchar no 12 yes no yes Chinese_PRC_CI_AS
CredentialType varchar no 8 yes no yes Chinese_PRC_CI_AS
CredentialPeriod datetime no 8 yes (n/a) (n/a) NULL
CredentialNO nvarchar no 36 yes (n/a) (n/a) Chinese_PRC_CI_AS
WorkLength decimal no 9 18 0 yes (n/a) (n/a) NULL
Education varchar no 8 yes no yes Chinese_PRC_CI_AS
PositionCode varchar no 8 yes no yes Chinese_PRC_CI_AS
CompanyIndustry varchar no 8 yes no yes Chinese_PRC_CI_AS
CompanyNature varchar no 8 yes no yes Chinese_PRC_CI_AS
BillPostAddress varchar no 2 yes no yes Chinese_PRC_CI_AS
ResidentialStatus varchar no 8 yes no yes Chinese_PRC_CI_AS
SalaryAT money no 8 19 4 yes (n/a) (n/a) NULL
IsAcceptCreditQuantity char no 1 yes no yes Chinese_PRC_CI_AS
IsEmployeeCard int no 4 10 0 yes (n/a) (n/a) NULL
OnlineCheckResult nvarchar no 10 yes (n/a) (n/a) Chinese_PRC_CI_AS
ImportDate datetime no 8 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_MobileBusinessBranchData clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ImportDate DF_MobileBusinessBranchData_ImportDate (n/a) (n/a) (n/a) (n/a) (getdate())
PRIMARY KEY (clustered) PK_MobileBusinessBranchData (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[MobileBusinessBranchData]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[MobileBusinessBranchData]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
WorkflowTaskData CCOS_DBOperation user table 2010-11-10 13:59:04.473
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
CPCTaskId int no 4 10 0 no (n/a) (n/a) NULL
CPCInstanceId int no 4 10 0 yes (n/a) (n/a) NULL
CPCServiceCode char no 8 no no no Chinese_PRC_CI_AS
WorkflowInstanceId varchar no 60 yes no yes Chinese_PRC_CI_AS
WorkflowTaskId varchar no 60 yes no yes Chinese_PRC_CI_AS
WorkflowTaskName varchar no 100 yes no yes Chinese_PRC_CI_AS
BranchId varchar no 16 yes no yes Chinese_PRC_CI_AS
UserId varchar no 16 yes no yes Chinese_PRC_CI_AS
ProcessDateTime datetime no 8 yes (n/a) (n/a) NULL
ProcessStatus varchar no 16 yes no yes Chinese_PRC_CI_AS
ProcessComment nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
CPCTaskBusinessStatus varchar no 5 yes no yes Chinese_PRC_CI_AS
BusinessId varchar no 20 no no no Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WorkflowTaskData_PK clustered, unique, primary key located on PRIMARY CPCTaskId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column CPCInstanceId DF_WorkflowTaskData_CPCInstanceId (n/a) (n/a) (n/a) (n/a) ((0))
PRIMARY KEY (clustered) WorkflowTaskData_PK (n/a) (n/a) (n/a) (n/a) CPCTaskId
Table is referenced by foreign key
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CCOS_BusinessDB.CCOS.DataMatchTaskDetail: WorkflowTaskData_DataMatchTaskDetail_FK1
所有具有架构绑定的视图均未引用表 '[CCOS].[WorkflowTaskData]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceDoubleExcuseItemList CCOS_DBOperation user table 2011-03-15 11:11:20.553
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
SequenceId int no 4 10 0 no (n/a) (n/a) NULL
CompanyCode nvarchar no 100 yes (n/a) (n/a) Chinese_PRC_CI_AS
CompanyName nvarchar no 510 yes (n/a) (n/a) Chinese_PRC_CI_AS
CityName nvarchar no 200 yes (n/a) (n/a) Chinese_PRC_CI_AS
Remark nvarchar no 1000 yes (n/a) (n/a) Chinese_PRC_CI_AS
Status varchar no 1 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
SequenceId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceDoubleExcuseItemList clustered, unique, primary key located on PRIMARY SequenceId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceDoubleExcuseItemList (n/a) (n/a) (n/a) (n/a) SequenceId
没有外键引用表 '[CCOS].[ReferenceDoubleExcuseItemList]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceDoubleExcuseItemList]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
FtpBatchNumber CCOS_DBOperation user table 2010-12-10 14:54:09.907
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BusinessType varchar no 50 no no no Chinese_PRC_CI_AS
BatchNum int no 4 10 0 yes (n/a) (n/a) NULL
DataTime varchar no 50 yes no yes Chinese_PRC_CI_AS
BatchLengeh int no 4 10 0 yes (n/a) (n/a) NULL
PartFileName varchar no 50 yes no yes Chinese_PRC_CI_AS
IsVip varchar no 2 no no no Chinese_PRC_CI_AS
FullFileName varchar no 50 yes no yes Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_FtpBatchNumber clustered, unique, primary key located on PRIMARY BusinessType, IsVip
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_FtpBatchNumber (n/a) (n/a) (n/a) (n/a) BusinessType, IsVip
没有外键引用表 '[CCOS].[FtpBatchNumber]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[FtpBatchNumber]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferenceCityBranch CCOS_DBOperation user table 2011-02-22 10:23:21.190
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
BranchCode nvarchar no 16 no (n/a) (n/a) Chinese_PRC_CI_AS
CityCode nvarchar no 16 no (n/a) (n/a) Chinese_PRC_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferenceCityBranch clustered, unique, primary key located on PRIMARY BranchCode
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PRIMARY KEY (clustered) PK_ReferenceCityBranch (n/a) (n/a) (n/a) (n/a) BranchCode
没有外键引用表 '[CCOS].[ReferenceCityBranch]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferenceCityBranch]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
ReferneceInspectItem CCOS_DBOperation user table 2011-04-26 18:57:39.463
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
InspectId int no 4 10 0 no (n/a) (n/a) NULL
ItemType varchar no 5 yes no yes Chinese_PRC_CI_AS
ItemName varchar no 50 yes no yes Chinese_PRC_CI_AS
ItemDesc varchar no 2048 yes no yes Chinese_PRC_CI_AS
DataSource varchar no 255 yes no yes Chinese_PRC_CI_AS
ImageDomainId varchar no 500 yes no yes Chinese_PRC_CI_AS
DocumentCategory varchar no 50 yes no yes Chinese_PRC_CI_AS
ChannelCode varchar no 50 yes no yes Chinese_PRC_CI_AS
VoucherType varchar no 50 yes no yes Chinese_PRC_CI_AS
OrderId int no 4 10 0 yes (n/a) (n/a) NULL
Enabled bit no 1 yes (n/a) (n/a) NULL
ErrorCode varchar no 5 yes no yes Chinese_PRC_CI_AS
SecondCard int no 4 10 0 yes (n/a) (n/a) NULL
ErrorLevel int no 4 10 0 yes (n/a) (n/a) NULL
ErrorReturnCounter int no 4 10 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
No identity column defined. NULL NULL NULL
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_ReferneceInspectItem clustered, unique, primary key located on PRIMARY InspectId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DEFAULT on column ErrorLevel DF_ReferneceInspectItem_ErrorLevel (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column ErrorReturnCounter DF_ReferneceInspectItem_ErrorReturnCounter (n/a) (n/a) (n/a) (n/a) ((0))
DEFAULT on column SecondCard DF_ReferneceInspectItem_SecondCard (n/a) (n/a) (n/a) (n/a) ((0))
PRIMARY KEY (clustered) PK_ReferneceInspectItem (n/a) (n/a) (n/a) (n/a) InspectId
没有外键引用表 '[CCOS].[ReferneceInspectItem]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[ReferneceInspectItem]'。
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
DataMatchItem CCOS_DBOperation user table 2011-01-18 20:22:34.693
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
MatchItemId int no 4 10 0 no (n/a) (n/a) NULL
MatchTaskId int no 4 10 0 no (n/a) (n/a) NULL
VoucherType varchar no 5 yes no yes Chinese_PRC_CI_AS
ElementField varchar no 50 no no no Chinese_PRC_CI_AS
ElementValue nvarchar no 508 yes (n/a) (n/a) Chinese_PRC_CI_AS
UserId varchar no 16 no no no Chinese_PRC_CI_AS
IsFromSOP bit no 1 yes (n/a) (n/a) NULL
SourceType varchar no 50 yes no yes Chinese_PRC_CI_AS
VoucherIndex smallint no 2 5 0 yes (n/a) (n/a) NULL
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
MatchItemId 1 1 0
RowGuidCol
--------------------------------------------------------------------------------------------------------------------------------
No rowguidcol column defined.
Data_located_on_filegroup
--------------------------------------------------------------------------------------------------------------------------------
PRIMARY
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PK_DataMatchItem clustered, unique, primary key located on PRIMARY MatchItemId
constraint_type constraint_name delete_action update_action status_enabled status_for_replication constraint_keys
-------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
FOREIGN KEY FK_DataMatchTaskDetail_DataMatchItem No Action No Action Enabled Is_For_Replication MatchTaskId
REFERENCES CCOS_BusinessDB.CCOS.DataMatchTaskDetail (MatchTaskId)
PRIMARY KEY (clustered) PK_DataMatchItem (n/a) (n/a) (n/a) (n/a) MatchItemId
没有外键引用表 '[CCOS].[DataMatchItem]',或者您没有引用表的相关权限。
所有具有架构绑定的视图均未引用表 '[CCOS].[DataMatchItem]'。