ACS3 Data Model

BBOARD_TOPICS

Name	Type	Nullable	Default value
TOPIC_ID	NUMBER(38)	N
TOPIC	VARCHAR2(200.0)	N
READ_ACCESS	VARCHAR2(16.0)	Y	'any'
WRITE_ACCESS	VARCHAR2(16.0)	Y	'public'
USERS_CAN_INITIATE_THREADS_P	CHAR(1.0)	Y	't'
BACKLINK	VARCHAR2(4000.0)	Y
BACKLINK_TITLE	VARCHAR2(4000.0)	Y
BLATHER	VARCHAR2(4000.0)	Y
RESTRICTED_P	CHAR(1.0)	Y	'f'
PRIMARY_MAINTAINER_ID	NUMBER(38)	N
SUBJECT_LINE_SUFFIX	VARCHAR2(40.0)	Y
NOTIFY_OF_NEW_POSTINGS_P	CHAR(1.0)	Y	't'
PRE_POST_CAVEAT	VARCHAR2(4000.0)	Y
MODERATION_POLICY	VARCHAR2(40.0)	Y
POLICY_STATEMENT	VARCHAR2(4000.0)	Y
PRESENTATION_TYPE	VARCHAR2(20.0)	Y	'q_and_a'
Q_AND_A_SORT_ORDER	VARCHAR2(4.0)	N	'asc'
Q_AND_A_CATEGORIZED_P	CHAR(1.0)	Y	'f'
Q_AND_A_NEW_DAYS	NUMBER(38)	Y	7
Q_AND_A_SOLICIT_CATEGORY_P	CHAR(1.0)	Y	't'
Q_AND_A_CATS_USER_EXTENSIBLE_P	CHAR(1.0)	Y	'f'
Q_AND_A_USE_INTEREST_LEVEL_P	CHAR(1.0)	Y	't'
Q_AND_A_SHOW_CATS_ONLY_P	CHAR(1.0)	Y	'f'
CUSTOM_SORT_KEY_P	CHAR(1.0)	Y	'f'
CUSTOM_SORT_KEY_NAME	VARCHAR2(50.0)	Y
CUSTOM_SORT_KEY_TYPE	VARCHAR2(20.0)	Y
CUSTOM_SORT_ORDER	VARCHAR2(4.0)	N	'asc'
CUSTOM_SORT_NOT_FOUND_TEXT	VARCHAR2(4000.0)	Y
CUSTOM_SORT_SOLICIT_P	CHAR(1.0)	Y	'f'
CUSTOM_SORT_SOLICIT_PRETTY_P	CHAR(1.0)	Y	'f'
CUSTOM_SORT_PRETTY_NAME	VARCHAR2(50.0)	Y
CUSTOM_SORT_PRETTY_EXPLANATION	VARCHAR2(100.0)	Y
CUSTOM_SORT_VALIDATION_CODE	VARCHAR2(4000.0)	Y
CATEGORY_CENTRIC_P	CHAR(1.0)	Y	'f'
UPLOADS_ANTICIPATED	VARCHAR2(30.0)	Y
ACTIVE_P	CHAR(1.0)	Y	't'
GROUP_ID	NUMBER(38)	Y
DEFAULT_TOPIC_P	VARCHAR2(1.0)	Y	't'
COLOR	VARCHAR2(7.0)	Y
ICON_ID	NUMBER(38)	Y

Constraint Name	Columns
SYS_C002087514	TOPIC_ID

Constraint Name	Check Condition
CHECK_PRESENTATION_TYPE	presentation_type in ('q_and_a','threads', 'ed_com', 'usgeospatial')
SYS_C002087489	"TOPIC_ID" IS NOT NULL
SYS_C002087490	"TOPIC" IS NOT NULL
SYS_C002087491	"PRIMARY_MAINTAINER_ID" IS NOT NULL
SYS_C002087492	"Q_AND_A_SORT_ORDER" IS NOT NULL
SYS_C002087493	"CUSTOM_SORT_ORDER" IS NOT NULL
SYS_C002087494	read_access in ('any','public','group')
SYS_C002087495	write_access in ('public','group')
SYS_C002087496	users_can_initiate_threads_p in ('t','f')
SYS_C002087497	restricted_p in ('t','f')
SYS_C002087498	notify_of_new_postings_p in ('t','f')
SYS_C002087500	q_and_a_sort_order in ('asc','desc')
SYS_C002087501	q_and_a_categorized_p in ('t','f')
SYS_C002087502	q_and_a_solicit_category_p in ('t','f')
SYS_C002087503	q_and_a_cats_user_extensible_p in ('t','f')
SYS_C002087504	q_and_a_use_interest_level_p in ('t','f')
SYS_C002087505	q_and_a_show_cats_only_p in ('t','f')
SYS_C002087506	custom_sort_key_p in ('t','f')
SYS_C002087507	custom_sort_order in ('asc','desc')
SYS_C002087508	custom_sort_solicit_p in ('t','f')
SYS_C002087509	custom_sort_solicit_pretty_p in ('t','f')
SYS_C002087510	category_centric_p in ('t','f')
SYS_C002087511	uploads_anticipated in ('images','files','images_or_files')
SYS_C002087512	active_p in ('t','f')
SYS_C002087513	default_topic_p in ('t','f')

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
SYS_C002087516	PRIMARY_MAINTAINER_ID	USERS	SYS_C002087135	NO ACTION
SYS_C002087517	GROUP_ID	USER_GROUPS	SYS_C002087305	NO ACTION
SYS_C002087518	ICON_ID	BBOARD_ICONS	SYS_C002087488	NO ACTION

Constraint name	Columns
SYS_C002087515	TOPIC

Index Name	Type	Unuqueness	Columns
SYS_C002087514	NORMAL	UNIQUE	TOPIC_ID
SYS_C002087515	NORMAL	UNIQUE	TOPIC

Generated by OraSchemaDoc, (c) Aram Kananov, 2002