Table: udf_option
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
entity_type |
decimal(15) |
|
udf_setup |
fk_udf_option1 |
| 2. |
PK |
udf_number |
decimal(15) |
|
udf_setup |
fk_udf_option1 |
| 3. |
PK |
value |
varchar(128) |
|
|
|
| 4. |
|
text |
varchar(128) |
|
|
|
| 5. |
|
sort_order |
decimal(15) |
((0)) |
|
|
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| entity_type |
udf_setup |
entity_type |
fk_udf_option1 |
| udf_number |
|
udf_number |
|
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_udf_option |
true |
entity_type |
Asc |
| |
|
udf_number |
|
| |
|
value |
|
| idx_udf_option1 |
true |
entity_type |
Asc |
| |
|
udf_number |
|
| |
|
text |
|