dbo.documentation_custom_fields - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	documentation_custom_fields
Module	Custom fields
Type	Metadata
Status	Active

Table holds mapping of custom fields to extended properties (SQL Server/Azure SQL). Custom field can be mapped to different extended property in each database.

Columns

		Name	Data type	Attributes	References	Description	Type	Status
	1	documentation_custom_field_id	int	Identity		Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2	custom_field_id	int		dbo.custom_fields (Custom fields)	Ref: custom_fields	Metadata	Active
Ref: custom_fields References: dbo.custom_fields (Custom fields) Type: Metadata Status: Active
	3	database_id	int		dbo.databases (Documentations)	Ref: databases	Metadata	Active
Ref: databases References: dbo.databases (Documentations) Type: Metadata Status: Active
	4	extended_property	nvarchar(128)			Name of the extended property	Metadata	Active
Name of the extended property Type: Metadata Status: Active
	5	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	6	created_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that created row	Metadata	Active
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active
	7	last_modification_date	datetime	Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	8	modified_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active
	9	source_id	int			For internal use only	Internal	Active
For internal use only Type: Internal Status: Active

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.documentation_custom_fields	dbo.custom_fields (Custom fields)	dbo.documentation_custom_fields.custom_field_id = dbo.custom_fields.custom_field_id	FK_documentation_custom_fields_custom_fields
dbo.documentation_custom_fields.custom_field_id = dbo.custom_fields.custom_field_id Name: FK_documentation_custom_fields_custom_fields
dbo.documentation_custom_fields	dbo.databases (Documentations)	dbo.documentation_custom_fields.database_id = dbo.databases.database_id	FK_documentation_custom_fields_databases
dbo.documentation_custom_fields.database_id = dbo.databases.database_id Name: FK_documentation_custom_fields_databases

Unique keys

	Key name	Columns	Description
	PK_documentation_custom_fields	documentation_custom_field_id	Table primary key
Table primary key
	UK_documentation_custom_fields	custom_field_id, database_id	Field can be mapped only once per connection
Field can be mapped only once per connection

Triggers

	Key name	When
	trg_documentation_custom_fields_Modify	After Insert, Update
-- ============================================= -- Author: Łukasz Gil -- Create date: 2017-09-22 -- Description: Updates last_modification_date, modified_by custom_fields on insert or update -- ============================================= CREATE TRIGGER [trg_documentation_custom_fields_Modify] ON [documentation_custom_fields] AFTER INSERT,UPDATE AS BEGIN UPDATE [documentation_custom_fields] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE documentation_custom_field_id IN (SELECT DISTINCT documentation_custom_field_id FROM Inserted) END
-- ============================================= -- Author: Łukasz Gil -- Create date: 2017-09-22 -- Description: Updates last_modification_date, modified_by custom_fields on insert or update -- ============================================= CREATE TRIGGER [trg_documentation_custom_fields_Modify] ON [documentation_custom_fields] AFTER INSERT,UPDATE AS BEGIN UPDATE [documentation_custom_fields] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE documentation_custom_field_id IN (SELECT DISTINCT documentation_custom_field_id FROM Inserted) END

Key name

When

Description

trg_documentation_custom_fields_Modify

After Insert, Update

Uses

Name
dbo.documentation_custom_fields
dbo.custom_fields (Custom fields)
dbo.databases (Documentations)
dbo.trg_documentation_custom_fields_Modify
dbo.documentation_custom_fields

Used by

Name
dbo.documentation_custom_fields
dbo.trg_documentation_custom_fields_Modify

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07