Reference for database field types

<< Click to Display Table of Contents >>

Navigation: Appendix > SQLServer topics >

Reference for database field types

Database field types

Database tables schema

Here is a reference for the fields datatype of main database tables

DBW_ATTACHMENTS
PK	Field Name	Data Type	Allow Nulls
	T	varchar(1)
	DESCRIPTION	varchar(80)
	FILE_NAME	varchar(256)
	FILE_DIRECTORY	varchar(256)
	REVISION	varchar(20)
	DOCUMENT_UNIQUE_ID	int

DBW_COMPANY_INFO
PK	Field Name	Data Type	Allow Nulls
	COMPANY_ID	varchar(50)
	SHARED_PATH	varchar(256)
	NETWORK_DRIVE	varchar(2)
	DBWSTDALONE_SERVER_PATH	varchar(255)
	DBW_TIME_ZONE_OFFSET	varchar(10)
	OFF_LINE	varchar(1)
	LOCAL_SERVER_NAME	varchar(50)
	REPLICATION_PARTNERS	varchar(128)
	DBWSTANDALONE_SERVER_PATH	varchar(255)
	DBW_REVISIONS_UNIQUE_ID_RANGE	varchar(50)

DBW_DRAWING_SHEETS
PK	Field Name	Data Type	Allow Nulls
	DOCUMENT_UNIQUE_ID	int
	SHEET_NAME	varchar(50)
	SHEET_FORMAT	varchar(50)
	SCALE	varchar(50)
	SHEET_PREVIEW_IMAGE	image

DBW_NOTIFICATIONS
PK	Field Name	Data Type	Allow Nulls
	NOTIFICATION_UID	int
	TYPE	int
	USERNAME	varchar(100)
	MESSAGE	varchar(MAX)
	DATE	datetime
	CONSUMED	bit
	EXPIRATION_DATE	datetime
	SENDER	varchar(100)
	DBWARM_GROUP	varchar(100)
	SUBSCRIPTION_UID	int

DBW_TASK_COMMANDS
PK	Field Name	Data Type	Allow Nulls
	UNIQUE_ID	int
	TASK_UNIQUE_ID	int
	ORDER_NUMBER	int
	DOCUMENT_UNIQUE_ID	int
	TASK_STATE	int
	N_EXECUTIONS	int
	SHELL_COMMAND	varchar(512)
	PRE_STATUS	varchar(512)
	POST_STATUS	varchar(512)

DBW_TASK_EXEC_NODES
PK	Field Name	Data Type	Allow Nulls
	NAME	varchar(50)
	IP	varchar(16)
	APPLICATION	int
	IS_WS	bit
	STATUS	bit
	VISIBLE_NAME	varchar(50)

DBW_TASKS
PK	Field Name	Data Type	Allow Nulls
	UNIQUE_ID	int
	ACTION	int
	CREATED_BY	varchar(50)
	CREATION_DATE	datetime
	REQUESTING_WORKSTATION	varchar(50)
	TASK_STATE	int
	PROCESSING_WORKSTATION	varchar(50)
	APPLICATION	int
	DOCUMENT_SET	int
	PROCESS_START_DATE	datetime
	PROCESS_END_DATE	datetime
	PRIORITY	int

DBW_PARENT_CHILD_REVISION
PK	Field Name	Data Type	Allow Nulls
	PARENT_UNIQUE_ID	int
	CHILD_UNIQUE_ID	int
	PARENT_CHILD_INDEX	int
	PARENT_CHILD_QTY	float
	PARENT_CHILD_UM	varchar(20)
	PARENT_CHILD_MAKE_BUY	varchar(30)
	PARENT_CHILD_BOM_POS	varchar(20)
	PARENT_CHILD_REVISION	varchar(20)

DBW_PROJECT_USER
PK	Field Name	Data Type	Allow Nulls
	PROJECT_ID	varchar(128)
	USER_ID	varchar(128)

DBW_TASK_COMMANDS
PK	Field Name	Data Type	Allow Nulls
	UNIQUE_ID	int
	TASK_UNIQUE_ID	int
	ORDER_NUMBER	int
	DOCUMENT_UNIQUE_ID	int
	TASK_STATE	int
	N_EXECUTIONS	int
	SHELL_COMMAND	int
	PRE_STATUS	varchar(512)
	POST_STATUS	varchar(512)

DBW_COMPANY_INFO
PK	Field Name	Data Type	Allow Nulls
	DOCUMENT_UNIQUE_ID	int

DBWARM
PK	Field Name	Data Type	Allow Nulls
	GROUP_ID	varchar(128)
	RIGHTS	varchar(128)
	EXTENDED_RIGHTS	varchar(50)

DBWARM_CLASS_GROUP
PK	Field Name	Data Type	Allow Nulls
	CLASS_ID	varchar(50)
	LOGIN_GROUP	varchar(50)
	MASK_GROUP	varchar(50)

DBWORKS_USERS
PK	Field Name	Data Type	Allow Nulls
	USER_ID	varchar(128)
	FULLNAME	varchar(128)
	PASSWORD	varchar(128)
	GROUP_ID	varchar(128)
	PHONE	varchar(128)
	EMAIL	varchar(128)
	PIN	varchar(50)
	LOCKED	int
	TRUSTED_DOMAIN	varchar(50)
	INITIALS	varchar(10)
	ABBREV_NAME	varchar(128)