You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1682 lines
213 KiB
1682 lines
213 KiB
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_hr_employee\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_account_create_org\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_account_update_org\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_account_create_user\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_hr_employee_tb_sys_user\":{\"Pars\":{\"uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_account_update_user\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[]}")]
|
|
public class tb_hr_employee : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_hr_employee";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"email\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"varchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String email { get { return _email;} set { _email = value; SetDirty(tb_hr_employee.CN_EMAIL); } }
|
|
public const string CN_EMAIL = "email";
|
|
public const string DT_EMAIL = "varchar(255)";
|
|
private String _email;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"login_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String login_type { get { return _login_type;} set { _login_type = value; SetDirty(tb_hr_employee.CN_LOGIN_TYPE); } }
|
|
public const string CN_LOGIN_TYPE = "login_type";
|
|
public const string DT_LOGIN_TYPE = "char(1)";
|
|
private String _login_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_hr_employee.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"personal_setting\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String personal_setting { get { return _personal_setting;} set { _personal_setting = value; SetDirty(tb_hr_employee.CN_PERSONAL_SETTING); } }
|
|
public const string CN_PERSONAL_SETTING = "personal_setting";
|
|
public const string DT_PERSONAL_SETTING = "nvarchar(255)";
|
|
private String _personal_setting;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_hr_employee.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_hr_employee\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_hr_employee.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_hr_employee() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_api\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_api_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_api_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_api_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_api_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_api_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_api : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_api";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"group_column\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String group_column { get { return _group_column;} set { _group_column = value; SetDirty(tb_rpt_api.CN_GROUP_COLUMN); } }
|
|
public const string CN_GROUP_COLUMN = "group_column";
|
|
public const string DT_GROUP_COLUMN = "nvarchar(50)";
|
|
private String _group_column;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_api.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_api.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_api.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"time_column\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String time_column { get { return _time_column;} set { _time_column = value; SetDirty(tb_rpt_api.CN_TIME_COLUMN); } }
|
|
public const string CN_TIME_COLUMN = "time_column";
|
|
public const string DT_TIME_COLUMN = "nvarchar(50)";
|
|
private String _time_column;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_api\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"view_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String view_name { get { return _view_name;} set { _view_name = value; SetDirty(tb_rpt_api.CN_VIEW_NAME); } }
|
|
public const string CN_VIEW_NAME = "view_name";
|
|
public const string DT_VIEW_NAME = "nvarchar(50)";
|
|
private String _view_name;
|
|
|
|
|
|
public tb_rpt_api() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_apicolumn_api_uid\":{\"Pars\":{\"api_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_api\"},\"FK_tb_rpt_apicolumn_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_apicolumn_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_apicolumn_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_apicolumn_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_apicolumn_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_apicolumn : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_apicolumn";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"api_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_api\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_apicolumn_api_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String api_uid { get { return _api_uid;} set { _api_uid = value; SetDirty(tb_rpt_apicolumn.CN_API_UID); } }
|
|
public const string CN_API_UID = "api_uid";
|
|
public const string DT_API_UID = "varchar(36)";
|
|
private String _api_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"column_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_apicolumn.CN_COLUMN_TYPE); } }
|
|
public const string CN_COLUMN_TYPE = "column_type";
|
|
public const string DT_COLUMN_TYPE = "nvarchar(16)";
|
|
private String _column_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_apicolumn.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_apicolumn.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_apicolumn.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_apicolumn\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"trans_default\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String trans_default { get { return _trans_default;} set { _trans_default = value; SetDirty(tb_rpt_apicolumn.CN_TRANS_DEFAULT); } }
|
|
public const string CN_TRANS_DEFAULT = "trans_default";
|
|
public const string DT_TRANS_DEFAULT = "nvarchar(16)";
|
|
private String _trans_default;
|
|
|
|
|
|
public tb_rpt_apicolumn() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_authreport\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_authreport_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_authreport_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_authreport_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_authreport_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_authreport_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_authreport : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_authreport";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"active_time\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"varchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String active_time { get { return _active_time;} set { _active_time = value; SetDirty(tb_rpt_authreport.CN_ACTIVE_TIME); } }
|
|
public const string CN_ACTIVE_TIME = "active_time";
|
|
public const string DT_ACTIVE_TIME = "varchar(50)";
|
|
private String _active_time;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"database_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_authreport.CN_DATABASE_TYPE); } }
|
|
public const string CN_DATABASE_TYPE = "database_type";
|
|
public const string DT_DATABASE_TYPE = "varchar(16)";
|
|
private String _database_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"department_item\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String department_item { get { return _department_item;} set { _department_item = value; SetDirty(tb_rpt_authreport.CN_DEPARTMENT_ITEM); } }
|
|
public const string CN_DEPARTMENT_ITEM = "department_item";
|
|
public const string DT_DEPARTMENT_ITEM = "nvarchar(255)";
|
|
private String _department_item;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"group_items\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String group_items { get { return _group_items;} set { _group_items = value; SetDirty(tb_rpt_authreport.CN_GROUP_ITEMS); } }
|
|
public const string CN_GROUP_ITEMS = "group_items";
|
|
public const string DT_GROUP_ITEMS = "nvarchar(255)";
|
|
private String _group_items;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"mail\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_authreport.CN_MAIL); } }
|
|
public const string CN_MAIL = "mail";
|
|
public const string DT_MAIL = "nvarchar(255)";
|
|
private String _mail;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_authreport.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_authreport.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"report_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String report_type { get { return _report_type;} set { _report_type = value; SetDirty(tb_rpt_authreport.CN_REPORT_TYPE); } }
|
|
public const string CN_REPORT_TYPE = "report_type";
|
|
public const string DT_REPORT_TYPE = "varchar(36)";
|
|
private String _report_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_authreport.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_rpt_authreport() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_authreport_schedule_authreport_uid\":{\"Pars\":{\"authreport_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_authreport\"},\"FK_tb_rpt_authreport_schedule_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_authreport_schedule_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_authreport_schedule_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_authreport_schedule_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ_tb_rpt_authreport_schedule__DD701265E465EC31\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_authreport_schedule : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_authreport_schedule";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"authreport_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_authreport\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_authreport_schedule_authreport_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String authreport_uid { get { return _authreport_uid;} set { _authreport_uid = value; SetDirty(tb_rpt_authreport_schedule.CN_AUTHREPORT_UID); } }
|
|
public const string CN_AUTHREPORT_UID = "authreport_uid";
|
|
public const string DT_AUTHREPORT_UID = "varchar(36)";
|
|
private String _authreport_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"data_range_end\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":14,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? data_range_end { get { return _data_range_end;} set { _data_range_end = value; SetDirty(tb_rpt_authreport_schedule.CN_DATA_RANGE_END); } }
|
|
public const string CN_DATA_RANGE_END = "data_range_end";
|
|
public const string DT_DATA_RANGE_END = "datetime";
|
|
private DateTime? _data_range_end;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"data_range_start\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":13,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? data_range_start { get { return _data_range_start;} set { _data_range_start = value; SetDirty(tb_rpt_authreport_schedule.CN_DATA_RANGE_START); } }
|
|
public const string CN_DATA_RANGE_START = "data_range_start";
|
|
public const string DT_DATA_RANGE_START = "datetime";
|
|
private DateTime? _data_range_start;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"database_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_authreport_schedule.CN_DATABASE_TYPE); } }
|
|
public const string CN_DATABASE_TYPE = "database_type";
|
|
public const string DT_DATABASE_TYPE = "varchar(16)";
|
|
private String _database_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"department_item\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String department_item { get { return _department_item;} set { _department_item = value; SetDirty(tb_rpt_authreport_schedule.CN_DEPARTMENT_ITEM); } }
|
|
public const string CN_DEPARTMENT_ITEM = "department_item";
|
|
public const string DT_DEPARTMENT_ITEM = "nvarchar(255)";
|
|
private String _department_item;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"expected_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? expected_date { get { return _expected_date;} set { _expected_date = value; SetDirty(tb_rpt_authreport_schedule.CN_EXPECTED_DATE); } }
|
|
public const string CN_EXPECTED_DATE = "expected_date";
|
|
public const string DT_EXPECTED_DATE = "datetime";
|
|
private DateTime? _expected_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"extension_meta\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":12,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String extension_meta { get { return _extension_meta;} set { _extension_meta = value; SetDirty(tb_rpt_authreport_schedule.CN_EXTENSION_META); } }
|
|
public const string CN_EXTENSION_META = "extension_meta";
|
|
public const string DT_EXTENSION_META = "nvarchar(255)";
|
|
private String _extension_meta;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"group_items\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String group_items { get { return _group_items;} set { _group_items = value; SetDirty(tb_rpt_authreport_schedule.CN_GROUP_ITEMS); } }
|
|
public const string CN_GROUP_ITEMS = "group_items";
|
|
public const string DT_GROUP_ITEMS = "nvarchar(255)";
|
|
private String _group_items;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"handle_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((-1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? handle_flag { get { return _handle_flag;} set { _handle_flag = value; SetDirty(tb_rpt_authreport_schedule.CN_HANDLE_FLAG); } }
|
|
public const string CN_HANDLE_FLAG = "handle_flag";
|
|
public const string DT_HANDLE_FLAG = "int";
|
|
private int? _handle_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"ip\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":45,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":45,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(45)\",\"DescriptionExtension\":null}")]
|
|
public String ip { get { return _ip;} set { _ip = value; SetDirty(tb_rpt_authreport_schedule.CN_IP); } }
|
|
public const string CN_IP = "ip";
|
|
public const string DT_IP = "varchar(45)";
|
|
private String _ip;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"mail\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_authreport_schedule.CN_MAIL); } }
|
|
public const string CN_MAIL = "mail";
|
|
public const string DT_MAIL = "nvarchar(255)";
|
|
private String _mail;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"process_date\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":11,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? process_date { get { return _process_date;} set { _process_date = value; SetDirty(tb_rpt_authreport_schedule.CN_PROCESS_DATE); } }
|
|
public const string CN_PROCESS_DATE = "process_date";
|
|
public const string DT_PROCESS_DATE = "datetime";
|
|
private DateTime? _process_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":15,\"IsRequireFill\":true,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_authreport_schedule.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(-1)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"report_subtype\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":22,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String report_subtype { get { return _report_subtype;} set { _report_subtype = value; SetDirty(tb_rpt_authreport_schedule.CN_REPORT_SUBTYPE); } }
|
|
public const string CN_REPORT_SUBTYPE = "report_subtype";
|
|
public const string DT_REPORT_SUBTYPE = "nvarchar(50)";
|
|
private String _report_subtype;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_authreport_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_authreport_schedule.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_rpt_authreport_schedule() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_report_column\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_report_column_apicolumn_uid\":{\"Pars\":{\"apicolumn_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_apicolumn\"},\"FK_tb_rpt_report_column_report_mst_uid\":{\"Pars\":{\"report_mst_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_report_mst\"},\"FK_tb_rpt_report_column_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_column_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_column_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_report_column_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_report_column_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_report_column : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_report_column";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"apicolumn_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_apicolumn\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_column_apicolumn_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String apicolumn_uid { get { return _apicolumn_uid;} set { _apicolumn_uid = value; SetDirty(tb_rpt_report_column.CN_APICOLUMN_UID); } }
|
|
public const string CN_APICOLUMN_UID = "apicolumn_uid";
|
|
public const string DT_APICOLUMN_UID = "varchar(36)";
|
|
private String _apicolumn_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"report_mst_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_report_mst\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_column_report_mst_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_column.CN_REPORT_MST_UID); } }
|
|
public const string CN_REPORT_MST_UID = "report_mst_uid";
|
|
public const string DT_REPORT_MST_UID = "varchar(36)";
|
|
private String _report_mst_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"column_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":true,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_report_column.CN_COLUMN_TYPE); } }
|
|
public const string CN_COLUMN_TYPE = "column_type";
|
|
public const string DT_COLUMN_TYPE = "nvarchar(16)";
|
|
private String _column_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"column_width\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? column_width { get { return _column_width;} set { _column_width = value; SetDirty(tb_rpt_report_column.CN_COLUMN_WIDTH); } }
|
|
public const string CN_COLUMN_WIDTH = "column_width";
|
|
public const string DT_COLUMN_WIDTH = "int";
|
|
private int? _column_width;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_column.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"sequence\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":true,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? sequence { get { return _sequence;} set { _sequence = value; SetDirty(tb_rpt_report_column.CN_SEQUENCE); } }
|
|
public const string CN_SEQUENCE = "sequence";
|
|
public const string DT_SEQUENCE = "int";
|
|
private int? _sequence;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_column.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_column\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"trans\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String trans { get { return _trans;} set { _trans = value; SetDirty(tb_rpt_report_column.CN_TRANS); } }
|
|
public const string CN_TRANS = "trans";
|
|
public const string DT_TRANS = "nvarchar(50)";
|
|
private String _trans;
|
|
|
|
|
|
public tb_rpt_report_column() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_report_condition\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_report_condition_apicolumn_uid\":{\"Pars\":{\"apicolumn_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_apicolumn\"},\"FK_tb_rpt_report_condition_report_mst_uid\":{\"Pars\":{\"report_mst_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_report_mst\"},\"FK_tb_rpt_report_condition_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_condition_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_condition_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_report_condition_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_report_condition_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_report_condition : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_report_condition";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"apicolumn_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_apicolumn\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_condition_apicolumn_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String apicolumn_uid { get { return _apicolumn_uid;} set { _apicolumn_uid = value; SetDirty(tb_rpt_report_condition.CN_APICOLUMN_UID); } }
|
|
public const string CN_APICOLUMN_UID = "apicolumn_uid";
|
|
public const string DT_APICOLUMN_UID = "varchar(36)";
|
|
private String _apicolumn_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"report_mst_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_report_mst\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_condition_report_mst_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_condition.CN_REPORT_MST_UID); } }
|
|
public const string CN_REPORT_MST_UID = "report_mst_uid";
|
|
public const string DT_REPORT_MST_UID = "varchar(36)";
|
|
private String _report_mst_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"column_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":true,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_report_condition.CN_COLUMN_TYPE); } }
|
|
public const string CN_COLUMN_TYPE = "column_type";
|
|
public const string DT_COLUMN_TYPE = "nvarchar(16)";
|
|
private String _column_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"operation_type\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String operation_type { get { return _operation_type;} set { _operation_type = value; SetDirty(tb_rpt_report_condition.CN_OPERATION_TYPE); } }
|
|
public const string CN_OPERATION_TYPE = "operation_type";
|
|
public const string DT_OPERATION_TYPE = "nvarchar(50)";
|
|
private String _operation_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"operation_value\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String operation_value { get { return _operation_value;} set { _operation_value = value; SetDirty(tb_rpt_report_condition.CN_OPERATION_VALUE); } }
|
|
public const string CN_OPERATION_VALUE = "operation_value";
|
|
public const string DT_OPERATION_VALUE = "nvarchar(255)";
|
|
private String _operation_value;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_condition.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_condition\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_condition.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_rpt_report_condition() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_report_mst\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_report_mst_api_uid\":{\"Pars\":{\"api_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_api\"},\"FK_tb_rpt_report_mst_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_mst_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_mst_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_report_mst_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_rpt_report_mst_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_report_mst : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_report_mst";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"api_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_api\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_mst_api_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String api_uid { get { return _api_uid;} set { _api_uid = value; SetDirty(tb_rpt_report_mst.CN_API_UID); } }
|
|
public const string CN_API_UID = "api_uid";
|
|
public const string DT_API_UID = "varchar(36)";
|
|
private String _api_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"active_time\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String active_time { get { return _active_time;} set { _active_time = value; SetDirty(tb_rpt_report_mst.CN_ACTIVE_TIME); } }
|
|
public const string CN_ACTIVE_TIME = "active_time";
|
|
public const string DT_ACTIVE_TIME = "varchar(50)";
|
|
private String _active_time;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"database_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_report_mst.CN_DATABASE_TYPE); } }
|
|
public const string CN_DATABASE_TYPE = "database_type";
|
|
public const string DT_DATABASE_TYPE = "varchar(16)";
|
|
private String _database_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"footer_img_path\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String footer_img_path { get { return _footer_img_path;} set { _footer_img_path = value; SetDirty(tb_rpt_report_mst.CN_FOOTER_IMG_PATH); } }
|
|
public const string CN_FOOTER_IMG_PATH = "footer_img_path";
|
|
public const string DT_FOOTER_IMG_PATH = "nvarchar(255)";
|
|
private String _footer_img_path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"header_img_path\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String header_img_path { get { return _header_img_path;} set { _header_img_path = value; SetDirty(tb_rpt_report_mst.CN_HEADER_IMG_PATH); } }
|
|
public const string CN_HEADER_IMG_PATH = "header_img_path";
|
|
public const string DT_HEADER_IMG_PATH = "nvarchar(255)";
|
|
private String _header_img_path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"mail\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_report_mst.CN_MAIL); } }
|
|
public const string CN_MAIL = "mail";
|
|
public const string DT_MAIL = "nvarchar(255)";
|
|
private String _mail;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_report_mst.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":11,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_mst.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(255)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"schedule_frequency\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String schedule_frequency { get { return _schedule_frequency;} set { _schedule_frequency = value; SetDirty(tb_rpt_report_mst.CN_SCHEDULE_FREQUENCY); } }
|
|
public const string CN_SCHEDULE_FREQUENCY = "schedule_frequency";
|
|
public const string DT_SCHEDULE_FREQUENCY = "varchar(16)";
|
|
private String _schedule_frequency;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"server_group_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String server_group_name { get { return _server_group_name;} set { _server_group_name = value; SetDirty(tb_rpt_report_mst.CN_SERVER_GROUP_NAME); } }
|
|
public const string CN_SERVER_GROUP_NAME = "server_group_name";
|
|
public const string DT_SERVER_GROUP_NAME = "varchar(16)";
|
|
private String _server_group_name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_mst\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":12,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_mst.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_rpt_report_mst() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_rpt_report_schedule_report_mst_uid\":{\"Pars\":{\"report_mst_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_rpt_report_mst\"},\"FK_tb_rpt_report_schedule_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_schedule_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_rpt_report_schedule_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_rpt_report_schedule_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ_tb_rpt_report_schedule__DD701265E465EC31\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_rpt_report_schedule : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_rpt_report_schedule";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"report_mst_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_rpt_report_mst\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_rpt_report_schedule_report_mst_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_schedule.CN_REPORT_MST_UID); } }
|
|
public const string CN_REPORT_MST_UID = "report_mst_uid";
|
|
public const string DT_REPORT_MST_UID = "varchar(36)";
|
|
private String _report_mst_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"data_range_end\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":13,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? data_range_end { get { return _data_range_end;} set { _data_range_end = value; SetDirty(tb_rpt_report_schedule.CN_DATA_RANGE_END); } }
|
|
public const string CN_DATA_RANGE_END = "data_range_end";
|
|
public const string DT_DATA_RANGE_END = "datetime";
|
|
private DateTime? _data_range_end;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"data_range_start\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":12,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? data_range_start { get { return _data_range_start;} set { _data_range_start = value; SetDirty(tb_rpt_report_schedule.CN_DATA_RANGE_START); } }
|
|
public const string CN_DATA_RANGE_START = "data_range_start";
|
|
public const string DT_DATA_RANGE_START = "datetime";
|
|
private DateTime? _data_range_start;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"database_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_report_schedule.CN_DATABASE_TYPE); } }
|
|
public const string CN_DATABASE_TYPE = "database_type";
|
|
public const string DT_DATABASE_TYPE = "varchar(16)";
|
|
private String _database_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"expected_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? expected_date { get { return _expected_date;} set { _expected_date = value; SetDirty(tb_rpt_report_schedule.CN_EXPECTED_DATE); } }
|
|
public const string CN_EXPECTED_DATE = "expected_date";
|
|
public const string DT_EXPECTED_DATE = "datetime";
|
|
private DateTime? _expected_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"extension_meta\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":11,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String extension_meta { get { return _extension_meta;} set { _extension_meta = value; SetDirty(tb_rpt_report_schedule.CN_EXTENSION_META); } }
|
|
public const string CN_EXTENSION_META = "extension_meta";
|
|
public const string DT_EXTENSION_META = "nvarchar(255)";
|
|
private String _extension_meta;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"handle_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((-1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? handle_flag { get { return _handle_flag;} set { _handle_flag = value; SetDirty(tb_rpt_report_schedule.CN_HANDLE_FLAG); } }
|
|
public const string CN_HANDLE_FLAG = "handle_flag";
|
|
public const string DT_HANDLE_FLAG = "int";
|
|
private int? _handle_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"ip\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":45,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":45,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(45)\",\"DescriptionExtension\":null}")]
|
|
public String ip { get { return _ip;} set { _ip = value; SetDirty(tb_rpt_report_schedule.CN_IP); } }
|
|
public const string CN_IP = "ip";
|
|
public const string DT_IP = "varchar(45)";
|
|
private String _ip;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"mail\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_report_schedule.CN_MAIL); } }
|
|
public const string CN_MAIL = "mail";
|
|
public const string DT_MAIL = "nvarchar(255)";
|
|
private String _mail;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"process_date\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? process_date { get { return _process_date;} set { _process_date = value; SetDirty(tb_rpt_report_schedule.CN_PROCESS_DATE); } }
|
|
public const string CN_PROCESS_DATE = "process_date";
|
|
public const string DT_PROCESS_DATE = "datetime";
|
|
private DateTime? _process_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":14,\"IsRequireFill\":true,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_schedule.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(-1)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"server_group_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String server_group_name { get { return _server_group_name;} set { _server_group_name = value; SetDirty(tb_rpt_report_schedule.CN_SERVER_GROUP_NAME); } }
|
|
public const string CN_SERVER_GROUP_NAME = "server_group_name";
|
|
public const string DT_SERVER_GROUP_NAME = "varchar(16)";
|
|
private String _server_group_name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_rpt_report_schedule\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_schedule.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_rpt_report_schedule() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_action\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_action_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_action_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_action_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_action_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_action\",\"Item2\":[\"name\"]},{\"Item1\":\"UQ__tb_sys_a__DD701265EDEA1A0C\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_action : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_action";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_action\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_action.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_action.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_action.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_action() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_adintegration\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_adintegration_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_adintegration_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_adintegration_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_adintegration_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_adintegration\",\"Item2\":[\"location\"]},{\"Item1\":\"UQ_tb_sys_adintegration_uid\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_adintegration : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_adintegration";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegration\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"file_path\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String file_path { get { return _file_path;} set { _file_path = value; SetDirty(tb_sys_adintegration.CN_FILE_PATH); } }
|
|
public const string CN_FILE_PATH = "file_path";
|
|
public const string DT_FILE_PATH = "nvarchar(255)";
|
|
private String _file_path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegration\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"location\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_adintegration\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String location { get { return _location;} set { _location = value; SetDirty(tb_sys_adintegration.CN_LOCATION); } }
|
|
public const string CN_LOCATION = "location";
|
|
public const string DT_LOCATION = "nvarchar(50)";
|
|
private String _location;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegration\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_adintegration.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegration\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_adintegration.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_adintegration() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_adintegrationlog_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_adintegrationlog_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ_tb_sys_adintegrationlog\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_adintegrationlog : EntityBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_adintegrationlog";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_org_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_org\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_adintegrationlog_create_org_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_ORG_UID); } }
|
|
public const string CN_CREATE_ORG_UID = "create_org_uid";
|
|
public const string DT_CREATE_ORG_UID = "varchar(36)";
|
|
private String _create_org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_user\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_adintegrationlog_create_user_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_USER_UID); } }
|
|
public const string CN_CREATE_USER_UID = "create_user_uid";
|
|
public const string DT_CREATE_USER_UID = "varchar(36)";
|
|
private String _create_user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"(getdate())\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime? _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"location\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String location { get { return _location;} set { _location = value; SetDirty(tb_sys_adintegrationlog.CN_LOCATION); } }
|
|
public const string CN_LOCATION = "location";
|
|
public const string DT_LOCATION = "nvarchar(50)";
|
|
private String _location;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_adintegrationlog.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(-1)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"success_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? success_flag { get { return _success_flag;} set { _success_flag = value; SetDirty(tb_sys_adintegrationlog.CN_SUCCESS_FLAG); } }
|
|
public const string CN_SUCCESS_FLAG = "success_flag";
|
|
public const string DT_SUCCESS_FLAG = "int";
|
|
private int? _success_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_adintegrationlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"UQ_tb_sys_adintegrationlog\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":1,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_adintegrationlog.CN_UID); } }
|
|
public const string CN_UID = "uid";
|
|
public const string DT_UID = "varchar(36)";
|
|
private String _uid;
|
|
|
|
|
|
public tb_sys_adintegrationlog() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_dblock\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_bse_dblock_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_bse_dblock_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_bse_dblock_program_id\":{\"Pars\":{\"program_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_program\"},\"FK_tb_bse_dblock_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_bse_dblock_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_dblock_unique_data\",\"Item2\":[\"lock_uid\",\"table_uid\"]},{\"Item1\":\"UQ__tb_sys_d__DD701265BC5AAEDB\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_dblock : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_dblock";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"program_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_program\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_bse_dblock_program_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_dblock.CN_PROGRAM_UID); } }
|
|
public const string CN_PROGRAM_UID = "program_uid";
|
|
public const string DT_PROGRAM_UID = "varchar(36)";
|
|
private String _program_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_cust_desc\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String lock_cust_desc { get { return _lock_cust_desc;} set { _lock_cust_desc = value; SetDirty(tb_sys_dblock.CN_LOCK_CUST_DESC); } }
|
|
public const string CN_LOCK_CUST_DESC = "lock_cust_desc";
|
|
public const string DT_LOCK_CUST_DESC = "nvarchar(50)";
|
|
private String _lock_cust_desc;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_hostname\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String lock_hostname { get { return _lock_hostname;} set { _lock_hostname = value; SetDirty(tb_sys_dblock.CN_LOCK_HOSTNAME); } }
|
|
public const string CN_LOCK_HOSTNAME = "lock_hostname";
|
|
public const string DT_LOCK_HOSTNAME = "nvarchar(50)";
|
|
private String _lock_hostname;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_ip\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":39,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":39,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(39)\",\"DescriptionExtension\":null}")]
|
|
public String lock_ip { get { return _lock_ip;} set { _lock_ip = value; SetDirty(tb_sys_dblock.CN_LOCK_IP); } }
|
|
public const string CN_LOCK_IP = "lock_ip";
|
|
public const string DT_LOCK_IP = "varchar(39)";
|
|
private String _lock_ip;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_dblock_unique_data\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String lock_uid { get { return _lock_uid;} set { _lock_uid = value; SetDirty(tb_sys_dblock.CN_LOCK_UID); } }
|
|
public const string CN_LOCK_UID = "lock_uid";
|
|
public const string DT_LOCK_UID = "varchar(36)";
|
|
private String _lock_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_update_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":true,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? lock_update_date { get { return _lock_update_date;} set { _lock_update_date = value; SetDirty(tb_sys_dblock.CN_LOCK_UPDATE_DATE); } }
|
|
public const string CN_LOCK_UPDATE_DATE = "lock_update_date";
|
|
public const string DT_LOCK_UPDATE_DATE = "datetime";
|
|
private DateTime? _lock_update_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_update_org_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String lock_update_org_uid { get { return _lock_update_org_uid;} set { _lock_update_org_uid = value; SetDirty(tb_sys_dblock.CN_LOCK_UPDATE_ORG_UID); } }
|
|
public const string CN_LOCK_UPDATE_ORG_UID = "lock_update_org_uid";
|
|
public const string DT_LOCK_UPDATE_ORG_UID = "varchar(36)";
|
|
private String _lock_update_org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"lock_update_user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String lock_update_user_uid { get { return _lock_update_user_uid;} set { _lock_update_user_uid = value; SetDirty(tb_sys_dblock.CN_LOCK_UPDATE_USER_UID); } }
|
|
public const string CN_LOCK_UPDATE_USER_UID = "lock_update_user_uid";
|
|
public const string DT_LOCK_UPDATE_USER_UID = "varchar(36)";
|
|
private String _lock_update_user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_dblock\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"table_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_dblock_unique_data\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String table_uid { get { return _table_uid;} set { _table_uid = value; SetDirty(tb_sys_dblock.CN_TABLE_UID); } }
|
|
public const string CN_TABLE_UID = "table_uid";
|
|
public const string DT_TABLE_UID = "nvarchar(50)";
|
|
private String _table_uid;
|
|
|
|
|
|
public tb_sys_dblock() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"PKColumns\":[],\"ForeignRelations\":{},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_o__DD701265C9BE813D\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_exceptionlog : EntityBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_exceptionlog";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"(getdate())\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime? _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_org_uid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_ORG_UID); } }
|
|
public const string CN_CREATE_ORG_UID = "create_org_uid";
|
|
public const string DT_CREATE_ORG_UID = "varchar(36)";
|
|
private String _create_org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_user_uid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_USER_UID); } }
|
|
public const string CN_CREATE_USER_UID = "create_user_uid";
|
|
public const string DT_CREATE_USER_UID = "varchar(36)";
|
|
private String _create_user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"detail\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String detail { get { return _detail;} set { _detail = value; SetDirty(tb_sys_exceptionlog.CN_DETAIL); } }
|
|
public const string CN_DETAIL = "detail";
|
|
public const string DT_DETAIL = "nvarchar(-1)";
|
|
private String _detail;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"file_path\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String file_path { get { return _file_path;} set { _file_path = value; SetDirty(tb_sys_exceptionlog.CN_FILE_PATH); } }
|
|
public const string CN_FILE_PATH = "file_path";
|
|
public const string DT_FILE_PATH = "nvarchar(255)";
|
|
private String _file_path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"line_number\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? line_number { get { return _line_number;} set { _line_number = value; SetDirty(tb_sys_exceptionlog.CN_LINE_NUMBER); } }
|
|
public const string CN_LINE_NUMBER = "line_number";
|
|
public const string DT_LINE_NUMBER = "int";
|
|
private int? _line_number;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"member_name\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String member_name { get { return _member_name;} set { _member_name = value; SetDirty(tb_sys_exceptionlog.CN_MEMBER_NAME); } }
|
|
public const string CN_MEMBER_NAME = "member_name";
|
|
public const string DT_MEMBER_NAME = "nvarchar(255)";
|
|
private String _member_name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"parameters\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String parameters { get { return _parameters;} set { _parameters = value; SetDirty(tb_sys_exceptionlog.CN_PARAMETERS); } }
|
|
public const string CN_PARAMETERS = "parameters";
|
|
public const string DT_PARAMETERS = "nvarchar(-1)";
|
|
private String _parameters;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"program_uid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_exceptionlog.CN_PROGRAM_UID); } }
|
|
public const string CN_PROGRAM_UID = "program_uid";
|
|
public const string DT_PROGRAM_UID = "varchar(36)";
|
|
private String _program_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"UQ__tb_sys_o__DD701265C9BE813D\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":1,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_exceptionlog.CN_UID); } }
|
|
public const string CN_UID = "uid";
|
|
public const string DT_UID = "varchar(36)";
|
|
private String _uid;
|
|
|
|
|
|
public tb_sys_exceptionlog() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_manuallog\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_manuallog_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_manuallog_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ_tb_sys_manuallog\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_manuallog : EntityBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_manuallog";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_org_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_org\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_manuallog_create_org_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_manuallog.CN_CREATE_ORG_UID); } }
|
|
public const string CN_CREATE_ORG_UID = "create_org_uid";
|
|
public const string DT_CREATE_ORG_UID = "varchar(36)";
|
|
private String _create_org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_user\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_manuallog_create_user_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_manuallog.CN_CREATE_USER_UID); } }
|
|
public const string CN_CREATE_USER_UID = "create_user_uid";
|
|
public const string DT_CREATE_USER_UID = "varchar(36)";
|
|
private String _create_user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"action_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":16,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":16,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String action_name { get { return _action_name;} set { _action_name = value; SetDirty(tb_sys_manuallog.CN_ACTION_NAME); } }
|
|
public const string CN_ACTION_NAME = "action_name";
|
|
public const string DT_ACTION_NAME = "nvarchar(16)";
|
|
private String _action_name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"(getdate())\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_manuallog.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime? _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"message\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String message { get { return _message;} set { _message = value; SetDirty(tb_sys_manuallog.CN_MESSAGE); } }
|
|
public const string CN_MESSAGE = "message";
|
|
public const string DT_MESSAGE = "nvarchar(-1)";
|
|
private String _message;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"program_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_manuallog.CN_PROGRAM_UID); } }
|
|
public const string CN_PROGRAM_UID = "program_uid";
|
|
public const string DT_PROGRAM_UID = "varchar(36)";
|
|
private String _program_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":-1,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(-1)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_manuallog.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(-1)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_manuallog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"UQ_tb_sys_manuallog\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":1,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_manuallog.CN_UID); } }
|
|
public const string CN_UID = "uid";
|
|
public const string DT_UID = "varchar(36)";
|
|
private String _uid;
|
|
|
|
|
|
public tb_sys_manuallog() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_module\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_module_parent\":{\"Pars\":{\"parent\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_module\"},\"FK_tb_sys_module_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_module_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_module_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_module_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_module\",\"Item2\":[\"name\"]},{\"Item1\":\"UQ__tb_sys_m__DD701265E465EC31\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_module : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_module";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"parent\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_module\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_module_parent\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String parent { get { return _parent;} set { _parent = value; SetDirty(tb_sys_module.CN_PARENT); } }
|
|
public const string CN_PARENT = "parent";
|
|
public const string DT_PARENT = "varchar(36)";
|
|
private String _parent;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"code\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_module.CN_CODE); } }
|
|
public const string CN_CODE = "code";
|
|
public const string DT_CODE = "nvarchar(50)";
|
|
private String _code;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"memo\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_module.CN_MEMO); } }
|
|
public const string CN_MEMO = "memo";
|
|
public const string DT_MEMO = "nvarchar(255)";
|
|
private String _memo;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_module\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_module.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_module.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"seq\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1000))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_module.CN_SEQ); } }
|
|
public const string CN_SEQ = "seq";
|
|
public const string DT_SEQ = "int";
|
|
private int? _seq;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_module\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_module.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_module() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_org\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_org_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_org_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_org_tb_sys_user_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_org_tb_sys_user_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_o__DD701265C9BE813C\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_org : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_org";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"email\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":320,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":320,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"varchar(320)\",\"DescriptionExtension\":null}")]
|
|
public String email { get { return _email;} set { _email = value; SetDirty(tb_sys_org.CN_EMAIL); } }
|
|
public const string CN_EMAIL = "email";
|
|
public const string DT_EMAIL = "varchar(320)";
|
|
private String _email;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_org.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_org.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_org() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_param\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_param_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_param_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_param_paramcatalog\":{\"Pars\":{\"paramcatalog\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_paramcatalog\"},\"FK_tb_sys_param_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_param_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_p__DD701265D7E07509\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_param : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_param";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"paramcatalog\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_paramcatalog\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_param_paramcatalog\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String paramcatalog { get { return _paramcatalog;} set { _paramcatalog = value; SetDirty(tb_sys_param.CN_PARAMCATALOG); } }
|
|
public const string CN_PARAMCATALOG = "paramcatalog";
|
|
public const string DT_PARAMCATALOG = "varchar(36)";
|
|
private String _paramcatalog;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_param.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"param_value\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String param_value { get { return _param_value;} set { _param_value = value; SetDirty(tb_sys_param.CN_PARAM_VALUE); } }
|
|
public const string CN_PARAM_VALUE = "param_value";
|
|
public const string DT_PARAM_VALUE = "nvarchar(50)";
|
|
private String _param_value;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_param.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"seq\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_param.CN_SEQ); } }
|
|
public const string CN_SEQ = "seq";
|
|
public const string DT_SEQ = "int";
|
|
private int? _seq;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_param.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_param\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_param.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_param() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_paramcatalog\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_paramcatalog_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_paramcatalog_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_paramcatalog_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_paramcatalog_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_paramcatalog\",\"Item2\":[\"name\"]},{\"Item1\":\"UQ__tb_sys_p__DD701265C9B37F66\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_paramcatalog : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_paramcatalog";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_paramcatalog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_paramcatalog\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_paramcatalog.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_paramcatalog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_paramcatalog.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_paramcatalog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_paramcatalog.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_paramcatalog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_paramcatalog.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_paramcatalog() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_program\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_program_module_id\":{\"Pars\":{\"module_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_module\"},\"FK_tb_sys_program_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_program_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_program\",\"Item2\":[\"name\"]},{\"Item1\":\"UQ__tb_sys_p__DD70126535559116\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_program : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_program";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"module_uid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_module\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_program_module_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String module_uid { get { return _module_uid;} set { _module_uid = value; SetDirty(tb_sys_program.CN_MODULE_UID); } }
|
|
public const string CN_MODULE_UID = "module_uid";
|
|
public const string DT_MODULE_UID = "varchar(36)";
|
|
private String _module_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"code\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_program.CN_CODE); } }
|
|
public const string CN_CODE = "code";
|
|
public const string DT_CODE = "nvarchar(50)";
|
|
private String _code;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"icon\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nchar\",\"CHARACTER_MAXIMUM_LENGTH\":20,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":20,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nchar(20)\",\"DescriptionExtension\":null}")]
|
|
public String icon { get { return _icon;} set { _icon = value; SetDirty(tb_sys_program.CN_ICON); } }
|
|
public const string CN_ICON = "icon";
|
|
public const string DT_ICON = "nchar(20)";
|
|
private String _icon;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"memo\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":10,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_program.CN_MEMO); } }
|
|
public const string CN_MEMO = "memo";
|
|
public const string DT_MEMO = "nvarchar(255)";
|
|
private String _memo;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"menudisplay\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":8,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String menudisplay { get { return _menudisplay;} set { _menudisplay = value; SetDirty(tb_sys_program.CN_MENUDISPLAY); } }
|
|
public const string CN_MENUDISPLAY = "menudisplay";
|
|
public const string DT_MENUDISPLAY = "char(1)";
|
|
private String _menudisplay;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_program\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_program.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":11,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_program.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"rout_path\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":\"(N'/404')\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String rout_path { get { return _rout_path;} set { _rout_path = value; SetDirty(tb_sys_program.CN_ROUT_PATH); } }
|
|
public const string CN_ROUT_PATH = "rout_path";
|
|
public const string DT_ROUT_PATH = "nvarchar(255)";
|
|
private String _rout_path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"seq\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1000))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":9,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_program.CN_SEQ); } }
|
|
public const string CN_SEQ = "seq";
|
|
public const string DT_SEQ = "int";
|
|
private int? _seq;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_program() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_program2action\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_program2action_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program2action_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program2action_tb_sys_program\":{\"Pars\":{\"program_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_program\"},\"FK_tb_sys_program2action_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_program2action_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_program2action\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_program2action : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_program2action";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"program_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_program\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_program2action_tb_sys_program\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_program2action.CN_PROGRAM_UID); } }
|
|
public const string CN_PROGRAM_UID = "program_uid";
|
|
public const string DT_PROGRAM_UID = "varchar(36)";
|
|
private String _program_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"action_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String action_name { get { return _action_name;} set { _action_name = value; SetDirty(tb_sys_program2action.CN_ACTION_NAME); } }
|
|
public const string CN_ACTION_NAME = "action_name";
|
|
public const string DT_ACTION_NAME = "nvarchar(50)";
|
|
private String _action_name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"sequence\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1000))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? sequence { get { return _sequence;} set { _sequence = value; SetDirty(tb_sys_program2action.CN_SEQUENCE); } }
|
|
public const string CN_SEQUENCE = "sequence";
|
|
public const string DT_SEQUENCE = "int";
|
|
private int? _sequence;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program2action.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_program2action() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_program2action_grant\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_program2action_grant_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program2action_grant_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_program2action_grant_program2action_uid\":{\"Pars\":{\"program2action_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_program2action\"},\"FK_tb_sys_program2action_grant_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_program2action_grant_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UX_tb_sys_program2action_grant\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_program2action_grant : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_program2action_grant";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action_grant\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"program2action_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_program2action\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_program2action_grant_program2action_uid\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String program2action_uid { get { return _program2action_uid;} set { _program2action_uid = value; SetDirty(tb_sys_program2action_grant.CN_PROGRAM2ACTION_UID); } }
|
|
public const string CN_PROGRAM2ACTION_UID = "program2action_uid";
|
|
public const string DT_PROGRAM2ACTION_UID = "varchar(36)";
|
|
private String _program2action_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action_grant\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"grant_type\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String grant_type { get { return _grant_type;} set { _grant_type = value; SetDirty(tb_sys_program2action_grant.CN_GRANT_TYPE); } }
|
|
public const string CN_GRANT_TYPE = "grant_type";
|
|
public const string DT_GRANT_TYPE = "varchar(36)";
|
|
private String _grant_type;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action_grant\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"grant_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String grant_uid { get { return _grant_uid;} set { _grant_uid = value; SetDirty(tb_sys_program2action_grant.CN_GRANT_UID); } }
|
|
public const string CN_GRANT_UID = "grant_uid";
|
|
public const string DT_GRANT_UID = "varchar(36)";
|
|
private String _grant_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_program2action_grant\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program2action_grant.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_program2action_grant() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_role\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_role_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_role_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_role_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_role_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_role\",\"Item2\":[\"name\"]},{\"Item1\":\"UQ__tb_sys_r__DD701265ED18D0C4\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_role : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_role";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"code\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_role.CN_CODE); } }
|
|
public const string CN_CODE = "code";
|
|
public const string DT_CODE = "nvarchar(50)";
|
|
private String _code;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"memo\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_role.CN_MEMO); } }
|
|
public const string CN_MEMO = "memo";
|
|
public const string DT_MEMO = "nvarchar(255)";
|
|
private String _memo;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_role\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_role.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"remark\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":7,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_role.CN_REMARK); } }
|
|
public const string CN_REMARK = "remark";
|
|
public const string DT_REMARK = "nvarchar(50)";
|
|
private String _remark;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_role.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_role.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_role() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_role2org\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_role2org_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_role2org_org_id\":{\"Pars\":{\"org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_role2org_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_role2org_role_id\":{\"Pars\":{\"role_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_role\"},\"FK_tb_sys_role2org_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_role2org_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_r__DD701265D8603BCB\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_role2org : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_role2org";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role2org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"org_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_org\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_role2org_org_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String org_uid { get { return _org_uid;} set { _org_uid = value; SetDirty(tb_sys_role2org.CN_ORG_UID); } }
|
|
public const string CN_ORG_UID = "org_uid";
|
|
public const string DT_ORG_UID = "varchar(36)";
|
|
private String _org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role2org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"role_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_role\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_role2org_role_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String role_uid { get { return _role_uid;} set { _role_uid = value; SetDirty(tb_sys_role2org.CN_ROLE_UID); } }
|
|
public const string CN_ROLE_UID = "role_uid";
|
|
public const string DT_ROLE_UID = "varchar(36)";
|
|
private String _role_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_role2org\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_role2org.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_role2org() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_session\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_bse_session_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_bse_session_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_bse_session_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_bse_session_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_s__DD701265F82973D5\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_session : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_session";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_session\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"role_name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String role_name { get { return _role_name;} set { _role_name = value; SetDirty(tb_sys_session.CN_ROLE_NAME); } }
|
|
public const string CN_ROLE_NAME = "role_name";
|
|
public const string DT_ROLE_NAME = "nvarchar(50)";
|
|
private String _role_name;
|
|
|
|
|
|
public tb_sys_session() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_system_setting\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_system_setting_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_system_setting_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_system_setting_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_system_setting_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_system_setting\",\"Item2\":[\"name\"]},{\"Item1\":\"IX_tb_sys_system_setting_id\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_system_setting : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_system_setting";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_system_setting\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"key_value\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String key_value { get { return _key_value;} set { _key_value = value; SetDirty(tb_sys_system_setting.CN_KEY_VALUE); } }
|
|
public const string CN_KEY_VALUE = "key_value";
|
|
public const string DT_KEY_VALUE = "nvarchar(255)";
|
|
private String _key_value;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_system_setting\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"memo\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_system_setting.CN_MEMO); } }
|
|
public const string CN_MEMO = "memo";
|
|
public const string DT_MEMO = "nvarchar(50)";
|
|
private String _memo;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_system_setting\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":20,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_system_setting\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":20,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(20)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_system_setting.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(20)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_system_setting\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_system_setting.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_system_setting\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_system_setting.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_system_setting() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_translation\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_translation_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_translation_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_translation_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_translation_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_translation_1\",\"Item2\":[\"uid\"]},{\"Item1\":\"IX_tb_sys_translation_name\",\"Item2\":[\"language\",\"name\"]}]}")]
|
|
public class tb_sys_translation : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_translation";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_translation\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"language\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":10,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_translation_name\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":10,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(10)\",\"DescriptionExtension\":null}")]
|
|
public String language { get { return _language;} set { _language = value; SetDirty(tb_sys_translation.CN_LANGUAGE); } }
|
|
public const string CN_LANGUAGE = "language";
|
|
public const string DT_LANGUAGE = "nvarchar(10)";
|
|
private String _language;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_translation\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"IX_tb_sys_translation_name\",\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_translation.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(50)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_translation\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"trans\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":30,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":30,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":true,\"DataType\":\"nvarchar(30)\",\"DescriptionExtension\":null}")]
|
|
public String trans { get { return _trans;} set { _trans = value; SetDirty(tb_sys_translation.CN_TRANS); } }
|
|
public const string CN_TRANS = "trans";
|
|
public const string DT_TRANS = "nvarchar(30)";
|
|
private String _trans;
|
|
|
|
|
|
public tb_sys_translation() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_uploadlog\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_uploadlog_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_uploadlog_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_uploadlog_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_uploadlog_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_uploadlog\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_uploadlog : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_uploadlog";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_uploadlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"module\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":32,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":32,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"nvarchar(32)\",\"DescriptionExtension\":null}")]
|
|
public String module { get { return _module;} set { _module = value; SetDirty(tb_sys_uploadlog.CN_MODULE); } }
|
|
public const string CN_MODULE = "module";
|
|
public const string DT_MODULE = "nvarchar(32)";
|
|
private String _module;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_uploadlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"name\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":64,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":64,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(64)\",\"DescriptionExtension\":null}")]
|
|
public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_uploadlog.CN_NAME); } }
|
|
public const string CN_NAME = "name";
|
|
public const string DT_NAME = "nvarchar(64)";
|
|
private String _name;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_uploadlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"path\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":255,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":255,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"nvarchar(255)\",\"DescriptionExtension\":null}")]
|
|
public String path { get { return _path;} set { _path = value; SetDirty(tb_sys_uploadlog.CN_PATH); } }
|
|
public const string CN_PATH = "path";
|
|
public const string DT_PATH = "nvarchar(255)";
|
|
private String _path;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_uploadlog\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_uploadlog.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_uploadlog() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_user\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_user_create_org_uid\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_user_update_org_uid\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_user_create_user_uid\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_user_update_user_uid\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"IX_tb_sys_user_1\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_user : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_user";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"account\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"nvarchar\",\"CHARACTER_MAXIMUM_LENGTH\":50,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":50,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"nvarchar(50)\",\"DescriptionExtension\":null}")]
|
|
public String account { get { return _account;} set { _account = value; SetDirty(tb_sys_user.CN_ACCOUNT); } }
|
|
public const string CN_ACCOUNT = "account";
|
|
public const string DT_ACCOUNT = "nvarchar(50)";
|
|
private String _account;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_user.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"system_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((0))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_user.CN_SYSTEM_FLAG); } }
|
|
public const string CN_SYSTEM_FLAG = "system_flag";
|
|
public const string DT_SYSTEM_FLAG = "int";
|
|
private int? _system_flag;
|
|
|
|
|
|
public tb_sys_user() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_user2entercode\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_user2password_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_user2password_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_user2password_user_id\":{\"Pars\":{\"user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ_tb_sys_user2entercode\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_user2entercode : EntityBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_user2entercode";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_org_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_org\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_user2password_create_org_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":6,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_user2entercode.CN_CREATE_ORG_UID); } }
|
|
public const string CN_CREATE_ORG_UID = "create_org_uid";
|
|
public const string DT_CREATE_ORG_UID = "varchar(36)";
|
|
private String _create_org_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_user\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_user2password_create_user_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":5,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_user2entercode.CN_CREATE_USER_UID); } }
|
|
public const string CN_CREATE_USER_UID = "create_user_uid";
|
|
public const string DT_CREATE_USER_UID = "varchar(36)";
|
|
private String _create_user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_user\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_user2password_user_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String user_uid { get { return _user_uid;} set { _user_uid = value; SetDirty(tb_sys_user2entercode.CN_USER_UID); } }
|
|
public const string CN_USER_UID = "user_uid";
|
|
public const string DT_USER_UID = "varchar(36)";
|
|
private String _user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"create_date\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"datetime\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"(getdate())\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":false,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_user2entercode.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime? _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"UQ_tb_sys_user2entercode\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":1,\"IsRequireFill\":false,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_user2entercode.CN_UID); } }
|
|
public const string CN_UID = "uid";
|
|
public const string DT_UID = "varchar(36)";
|
|
private String _uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2entercode\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"user_entercode\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":256,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":256,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(256)\",\"DescriptionExtension\":null}")]
|
|
public String user_entercode { get { return _user_entercode;} set { _user_entercode = value; SetDirty(tb_sys_user2entercode.CN_USER_ENTERCODE); } }
|
|
public const string CN_USER_ENTERCODE = "user_entercode";
|
|
public const string DT_USER_ENTERCODE = "varchar(256)";
|
|
private String _user_entercode;
|
|
|
|
|
|
public tb_sys_user2entercode() : base()
|
|
{
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_user2role\",\"PKColumns\":[],\"ForeignRelations\":{\"FK_tb_sys_user2role_create_org_id\":{\"Pars\":{\"create_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_user2role_update_org_id\":{\"Pars\":{\"update_org_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_org\"},\"FK_tb_sys_user2role_role_id\":{\"Pars\":{\"role_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_role\"},\"FK_tb_sys_user2role_create_user_id\":{\"Pars\":{\"create_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_user2role_update_user_id\":{\"Pars\":{\"update_user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"},\"FK_tb_sys_user2role_user_id\":{\"Pars\":{\"user_uid\":\"uid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"tb_sys_user\"}},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_u__DD70126517C7C67C\",\"Item2\":[\"uid\"]}]}")]
|
|
public class tb_sys_user2role : EntityBasicBase
|
|
{
|
|
public const string TABLENAME = "CHB_Report.tb_sys_user2role";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"role_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_role\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_user2role_role_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":3,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String role_uid { get { return _role_uid;} set { _role_uid = value; SetDirty(tb_sys_user2role.CN_ROLE_UID); } }
|
|
public const string CN_ROLE_UID = "role_uid";
|
|
public const string DT_ROLE_UID = "varchar(36)";
|
|
private String _role_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"user_uid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":true,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":false,\"IsFK\":true,\"PK_Table\":\"tb_sys_user\",\"PK_Column\":\"uid\",\"CONSTRAINT_NAME\":\"FK_tb_sys_user2role_user_id\",\"DELETE_RULE\":\"1\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":2,\"IsRequireFill\":true,\"DataType\":\"varchar(36)\",\"DescriptionExtension\":null}")]
|
|
public String user_uid { get { return _user_uid;} set { _user_uid = value; SetDirty(tb_sys_user2role.CN_USER_UID); } }
|
|
public const string CN_USER_UID = "user_uid";
|
|
public const string DT_USER_UID = "varchar(36)";
|
|
private String _user_uid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"isdefault\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"('N')\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":11,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String isdefault { get { return _isdefault;} set { _isdefault = value; SetDirty(tb_sys_user2role.CN_ISDEFAULT); } }
|
|
public const string CN_ISDEFAULT = "isdefault";
|
|
public const string DT_ISDEFAULT = "char(1)";
|
|
private String _isdefault;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"tb_sys_user2role\",\"TABLE_CATALOG\":\"CHB_Report\",\"COLUMN_NAME\":\"status_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"int\",\"CHARACTER_MAXIMUM_LENGTH\":null,\"COLUMN_DEFAULT\":\"((1))\",\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":false,\"IsString\":false,\"IsNumber\":true,\"MaxLength\":-1,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":10,\"NUMERIC_SCALE\":0,\"ORDINAL_POSITION\":4,\"IsRequireFill\":false,\"DataType\":\"int\",\"DescriptionExtension\":null}")]
|
|
public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_user2role.CN_STATUS_FLAG); } }
|
|
public const string CN_STATUS_FLAG = "status_flag";
|
|
public const string DT_STATUS_FLAG = "int";
|
|
private int? _status_flag;
|
|
|
|
|
|
public tb_sys_user2role() : base()
|
|
{
|
|
}
|
|
}
|
|
|