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

  1. [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\":[]}")]
  2. public class tb_hr_employee : EntityBasicBase
  3. {
  4. public const string TABLENAME = "CHB_Report.tb_hr_employee";
  5. [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}")]
  6. public String email { get { return _email;} set { _email = value; SetDirty(tb_hr_employee.CN_EMAIL); } }
  7. public const string CN_EMAIL = "email";
  8. public const string DT_EMAIL = "varchar(255)";
  9. private String _email;
  10. [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}")]
  11. public String login_type { get { return _login_type;} set { _login_type = value; SetDirty(tb_hr_employee.CN_LOGIN_TYPE); } }
  12. public const string CN_LOGIN_TYPE = "login_type";
  13. public const string DT_LOGIN_TYPE = "char(1)";
  14. private String _login_type;
  15. [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}")]
  16. public String name { get { return _name;} set { _name = value; SetDirty(tb_hr_employee.CN_NAME); } }
  17. public const string CN_NAME = "name";
  18. public const string DT_NAME = "nvarchar(50)";
  19. private String _name;
  20. [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}")]
  21. public String personal_setting { get { return _personal_setting;} set { _personal_setting = value; SetDirty(tb_hr_employee.CN_PERSONAL_SETTING); } }
  22. public const string CN_PERSONAL_SETTING = "personal_setting";
  23. public const string DT_PERSONAL_SETTING = "nvarchar(255)";
  24. private String _personal_setting;
  25. [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}")]
  26. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_hr_employee.CN_STATUS_FLAG); } }
  27. public const string CN_STATUS_FLAG = "status_flag";
  28. public const string DT_STATUS_FLAG = "int";
  29. private int? _status_flag;
  30. [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}")]
  31. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_hr_employee.CN_SYSTEM_FLAG); } }
  32. public const string CN_SYSTEM_FLAG = "system_flag";
  33. public const string DT_SYSTEM_FLAG = "int";
  34. private int? _system_flag;
  35. public tb_hr_employee() : base()
  36. {
  37. }
  38. }
  39. [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\"]}]}")]
  40. public class tb_rpt_api : EntityBasicBase
  41. {
  42. public const string TABLENAME = "CHB_Report.tb_rpt_api";
  43. [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}")]
  44. public String group_column { get { return _group_column;} set { _group_column = value; SetDirty(tb_rpt_api.CN_GROUP_COLUMN); } }
  45. public const string CN_GROUP_COLUMN = "group_column";
  46. public const string DT_GROUP_COLUMN = "nvarchar(50)";
  47. private String _group_column;
  48. [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}")]
  49. public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_api.CN_NAME); } }
  50. public const string CN_NAME = "name";
  51. public const string DT_NAME = "nvarchar(50)";
  52. private String _name;
  53. [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}")]
  54. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_api.CN_REMARK); } }
  55. public const string CN_REMARK = "remark";
  56. public const string DT_REMARK = "nvarchar(255)";
  57. private String _remark;
  58. [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}")]
  59. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_api.CN_STATUS_FLAG); } }
  60. public const string CN_STATUS_FLAG = "status_flag";
  61. public const string DT_STATUS_FLAG = "int";
  62. private int? _status_flag;
  63. [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}")]
  64. public String time_column { get { return _time_column;} set { _time_column = value; SetDirty(tb_rpt_api.CN_TIME_COLUMN); } }
  65. public const string CN_TIME_COLUMN = "time_column";
  66. public const string DT_TIME_COLUMN = "nvarchar(50)";
  67. private String _time_column;
  68. [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}")]
  69. public String view_name { get { return _view_name;} set { _view_name = value; SetDirty(tb_rpt_api.CN_VIEW_NAME); } }
  70. public const string CN_VIEW_NAME = "view_name";
  71. public const string DT_VIEW_NAME = "nvarchar(50)";
  72. private String _view_name;
  73. public tb_rpt_api() : base()
  74. {
  75. }
  76. }
  77. [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\"]}]}")]
  78. public class tb_rpt_apicolumn : EntityBasicBase
  79. {
  80. public const string TABLENAME = "CHB_Report.tb_rpt_apicolumn";
  81. [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}")]
  82. public String api_uid { get { return _api_uid;} set { _api_uid = value; SetDirty(tb_rpt_apicolumn.CN_API_UID); } }
  83. public const string CN_API_UID = "api_uid";
  84. public const string DT_API_UID = "varchar(36)";
  85. private String _api_uid;
  86. [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}")]
  87. public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_apicolumn.CN_COLUMN_TYPE); } }
  88. public const string CN_COLUMN_TYPE = "column_type";
  89. public const string DT_COLUMN_TYPE = "nvarchar(16)";
  90. private String _column_type;
  91. [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}")]
  92. public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_apicolumn.CN_NAME); } }
  93. public const string CN_NAME = "name";
  94. public const string DT_NAME = "nvarchar(50)";
  95. private String _name;
  96. [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}")]
  97. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_apicolumn.CN_REMARK); } }
  98. public const string CN_REMARK = "remark";
  99. public const string DT_REMARK = "nvarchar(255)";
  100. private String _remark;
  101. [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}")]
  102. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_apicolumn.CN_STATUS_FLAG); } }
  103. public const string CN_STATUS_FLAG = "status_flag";
  104. public const string DT_STATUS_FLAG = "int";
  105. private int? _status_flag;
  106. [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}")]
  107. public String trans_default { get { return _trans_default;} set { _trans_default = value; SetDirty(tb_rpt_apicolumn.CN_TRANS_DEFAULT); } }
  108. public const string CN_TRANS_DEFAULT = "trans_default";
  109. public const string DT_TRANS_DEFAULT = "nvarchar(16)";
  110. private String _trans_default;
  111. public tb_rpt_apicolumn() : base()
  112. {
  113. }
  114. }
  115. [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\"]}]}")]
  116. public class tb_rpt_authreport : EntityBasicBase
  117. {
  118. public const string TABLENAME = "CHB_Report.tb_rpt_authreport";
  119. [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}")]
  120. public String active_time { get { return _active_time;} set { _active_time = value; SetDirty(tb_rpt_authreport.CN_ACTIVE_TIME); } }
  121. public const string CN_ACTIVE_TIME = "active_time";
  122. public const string DT_ACTIVE_TIME = "varchar(50)";
  123. private String _active_time;
  124. [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}")]
  125. public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_authreport.CN_DATABASE_TYPE); } }
  126. public const string CN_DATABASE_TYPE = "database_type";
  127. public const string DT_DATABASE_TYPE = "varchar(16)";
  128. private String _database_type;
  129. [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}")]
  130. public String department_item { get { return _department_item;} set { _department_item = value; SetDirty(tb_rpt_authreport.CN_DEPARTMENT_ITEM); } }
  131. public const string CN_DEPARTMENT_ITEM = "department_item";
  132. public const string DT_DEPARTMENT_ITEM = "nvarchar(255)";
  133. private String _department_item;
  134. [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}")]
  135. public String group_items { get { return _group_items;} set { _group_items = value; SetDirty(tb_rpt_authreport.CN_GROUP_ITEMS); } }
  136. public const string CN_GROUP_ITEMS = "group_items";
  137. public const string DT_GROUP_ITEMS = "nvarchar(255)";
  138. private String _group_items;
  139. [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}")]
  140. public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_authreport.CN_MAIL); } }
  141. public const string CN_MAIL = "mail";
  142. public const string DT_MAIL = "nvarchar(255)";
  143. private String _mail;
  144. [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}")]
  145. public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_authreport.CN_NAME); } }
  146. public const string CN_NAME = "name";
  147. public const string DT_NAME = "nvarchar(50)";
  148. private String _name;
  149. [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}")]
  150. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_authreport.CN_REMARK); } }
  151. public const string CN_REMARK = "remark";
  152. public const string DT_REMARK = "nvarchar(255)";
  153. private String _remark;
  154. [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}")]
  155. public String report_type { get { return _report_type;} set { _report_type = value; SetDirty(tb_rpt_authreport.CN_REPORT_TYPE); } }
  156. public const string CN_REPORT_TYPE = "report_type";
  157. public const string DT_REPORT_TYPE = "varchar(36)";
  158. private String _report_type;
  159. [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}")]
  160. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_authreport.CN_STATUS_FLAG); } }
  161. public const string CN_STATUS_FLAG = "status_flag";
  162. public const string DT_STATUS_FLAG = "int";
  163. private int? _status_flag;
  164. public tb_rpt_authreport() : base()
  165. {
  166. }
  167. }
  168. [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\"]}]}")]
  169. public class tb_rpt_authreport_schedule : EntityBasicBase
  170. {
  171. public const string TABLENAME = "CHB_Report.tb_rpt_authreport_schedule";
  172. [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}")]
  173. public String authreport_uid { get { return _authreport_uid;} set { _authreport_uid = value; SetDirty(tb_rpt_authreport_schedule.CN_AUTHREPORT_UID); } }
  174. public const string CN_AUTHREPORT_UID = "authreport_uid";
  175. public const string DT_AUTHREPORT_UID = "varchar(36)";
  176. private String _authreport_uid;
  177. [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}")]
  178. public DateTime? data_range_end { get { return _data_range_end;} set { _data_range_end = value; SetDirty(tb_rpt_authreport_schedule.CN_DATA_RANGE_END); } }
  179. public const string CN_DATA_RANGE_END = "data_range_end";
  180. public const string DT_DATA_RANGE_END = "datetime";
  181. private DateTime? _data_range_end;
  182. [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}")]
  183. public DateTime? data_range_start { get { return _data_range_start;} set { _data_range_start = value; SetDirty(tb_rpt_authreport_schedule.CN_DATA_RANGE_START); } }
  184. public const string CN_DATA_RANGE_START = "data_range_start";
  185. public const string DT_DATA_RANGE_START = "datetime";
  186. private DateTime? _data_range_start;
  187. [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}")]
  188. public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_authreport_schedule.CN_DATABASE_TYPE); } }
  189. public const string CN_DATABASE_TYPE = "database_type";
  190. public const string DT_DATABASE_TYPE = "varchar(16)";
  191. private String _database_type;
  192. [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}")]
  193. public String department_item { get { return _department_item;} set { _department_item = value; SetDirty(tb_rpt_authreport_schedule.CN_DEPARTMENT_ITEM); } }
  194. public const string CN_DEPARTMENT_ITEM = "department_item";
  195. public const string DT_DEPARTMENT_ITEM = "nvarchar(255)";
  196. private String _department_item;
  197. [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}")]
  198. public DateTime? expected_date { get { return _expected_date;} set { _expected_date = value; SetDirty(tb_rpt_authreport_schedule.CN_EXPECTED_DATE); } }
  199. public const string CN_EXPECTED_DATE = "expected_date";
  200. public const string DT_EXPECTED_DATE = "datetime";
  201. private DateTime? _expected_date;
  202. [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}")]
  203. public String extension_meta { get { return _extension_meta;} set { _extension_meta = value; SetDirty(tb_rpt_authreport_schedule.CN_EXTENSION_META); } }
  204. public const string CN_EXTENSION_META = "extension_meta";
  205. public const string DT_EXTENSION_META = "nvarchar(255)";
  206. private String _extension_meta;
  207. [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}")]
  208. public String group_items { get { return _group_items;} set { _group_items = value; SetDirty(tb_rpt_authreport_schedule.CN_GROUP_ITEMS); } }
  209. public const string CN_GROUP_ITEMS = "group_items";
  210. public const string DT_GROUP_ITEMS = "nvarchar(255)";
  211. private String _group_items;
  212. [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}")]
  213. public int? handle_flag { get { return _handle_flag;} set { _handle_flag = value; SetDirty(tb_rpt_authreport_schedule.CN_HANDLE_FLAG); } }
  214. public const string CN_HANDLE_FLAG = "handle_flag";
  215. public const string DT_HANDLE_FLAG = "int";
  216. private int? _handle_flag;
  217. [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}")]
  218. public String ip { get { return _ip;} set { _ip = value; SetDirty(tb_rpt_authreport_schedule.CN_IP); } }
  219. public const string CN_IP = "ip";
  220. public const string DT_IP = "varchar(45)";
  221. private String _ip;
  222. [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}")]
  223. public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_authreport_schedule.CN_MAIL); } }
  224. public const string CN_MAIL = "mail";
  225. public const string DT_MAIL = "nvarchar(255)";
  226. private String _mail;
  227. [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}")]
  228. public DateTime? process_date { get { return _process_date;} set { _process_date = value; SetDirty(tb_rpt_authreport_schedule.CN_PROCESS_DATE); } }
  229. public const string CN_PROCESS_DATE = "process_date";
  230. public const string DT_PROCESS_DATE = "datetime";
  231. private DateTime? _process_date;
  232. [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}")]
  233. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_authreport_schedule.CN_REMARK); } }
  234. public const string CN_REMARK = "remark";
  235. public const string DT_REMARK = "nvarchar(-1)";
  236. private String _remark;
  237. [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}")]
  238. public String report_subtype { get { return _report_subtype;} set { _report_subtype = value; SetDirty(tb_rpt_authreport_schedule.CN_REPORT_SUBTYPE); } }
  239. public const string CN_REPORT_SUBTYPE = "report_subtype";
  240. public const string DT_REPORT_SUBTYPE = "nvarchar(50)";
  241. private String _report_subtype;
  242. [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}")]
  243. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_authreport_schedule.CN_STATUS_FLAG); } }
  244. public const string CN_STATUS_FLAG = "status_flag";
  245. public const string DT_STATUS_FLAG = "int";
  246. private int? _status_flag;
  247. public tb_rpt_authreport_schedule() : base()
  248. {
  249. }
  250. }
  251. [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\"]}]}")]
  252. public class tb_rpt_report_column : EntityBasicBase
  253. {
  254. public const string TABLENAME = "CHB_Report.tb_rpt_report_column";
  255. [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}")]
  256. public String apicolumn_uid { get { return _apicolumn_uid;} set { _apicolumn_uid = value; SetDirty(tb_rpt_report_column.CN_APICOLUMN_UID); } }
  257. public const string CN_APICOLUMN_UID = "apicolumn_uid";
  258. public const string DT_APICOLUMN_UID = "varchar(36)";
  259. private String _apicolumn_uid;
  260. [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}")]
  261. public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_column.CN_REPORT_MST_UID); } }
  262. public const string CN_REPORT_MST_UID = "report_mst_uid";
  263. public const string DT_REPORT_MST_UID = "varchar(36)";
  264. private String _report_mst_uid;
  265. [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}")]
  266. public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_report_column.CN_COLUMN_TYPE); } }
  267. public const string CN_COLUMN_TYPE = "column_type";
  268. public const string DT_COLUMN_TYPE = "nvarchar(16)";
  269. private String _column_type;
  270. [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}")]
  271. public int? column_width { get { return _column_width;} set { _column_width = value; SetDirty(tb_rpt_report_column.CN_COLUMN_WIDTH); } }
  272. public const string CN_COLUMN_WIDTH = "column_width";
  273. public const string DT_COLUMN_WIDTH = "int";
  274. private int? _column_width;
  275. [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}")]
  276. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_column.CN_REMARK); } }
  277. public const string CN_REMARK = "remark";
  278. public const string DT_REMARK = "nvarchar(255)";
  279. private String _remark;
  280. [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}")]
  281. public int? sequence { get { return _sequence;} set { _sequence = value; SetDirty(tb_rpt_report_column.CN_SEQUENCE); } }
  282. public const string CN_SEQUENCE = "sequence";
  283. public const string DT_SEQUENCE = "int";
  284. private int? _sequence;
  285. [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}")]
  286. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_column.CN_STATUS_FLAG); } }
  287. public const string CN_STATUS_FLAG = "status_flag";
  288. public const string DT_STATUS_FLAG = "int";
  289. private int? _status_flag;
  290. [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}")]
  291. public String trans { get { return _trans;} set { _trans = value; SetDirty(tb_rpt_report_column.CN_TRANS); } }
  292. public const string CN_TRANS = "trans";
  293. public const string DT_TRANS = "nvarchar(50)";
  294. private String _trans;
  295. public tb_rpt_report_column() : base()
  296. {
  297. }
  298. }
  299. [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\"]}]}")]
  300. public class tb_rpt_report_condition : EntityBasicBase
  301. {
  302. public const string TABLENAME = "CHB_Report.tb_rpt_report_condition";
  303. [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}")]
  304. public String apicolumn_uid { get { return _apicolumn_uid;} set { _apicolumn_uid = value; SetDirty(tb_rpt_report_condition.CN_APICOLUMN_UID); } }
  305. public const string CN_APICOLUMN_UID = "apicolumn_uid";
  306. public const string DT_APICOLUMN_UID = "varchar(36)";
  307. private String _apicolumn_uid;
  308. [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}")]
  309. public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_condition.CN_REPORT_MST_UID); } }
  310. public const string CN_REPORT_MST_UID = "report_mst_uid";
  311. public const string DT_REPORT_MST_UID = "varchar(36)";
  312. private String _report_mst_uid;
  313. [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}")]
  314. public String column_type { get { return _column_type;} set { _column_type = value; SetDirty(tb_rpt_report_condition.CN_COLUMN_TYPE); } }
  315. public const string CN_COLUMN_TYPE = "column_type";
  316. public const string DT_COLUMN_TYPE = "nvarchar(16)";
  317. private String _column_type;
  318. [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}")]
  319. public String operation_type { get { return _operation_type;} set { _operation_type = value; SetDirty(tb_rpt_report_condition.CN_OPERATION_TYPE); } }
  320. public const string CN_OPERATION_TYPE = "operation_type";
  321. public const string DT_OPERATION_TYPE = "nvarchar(50)";
  322. private String _operation_type;
  323. [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}")]
  324. public String operation_value { get { return _operation_value;} set { _operation_value = value; SetDirty(tb_rpt_report_condition.CN_OPERATION_VALUE); } }
  325. public const string CN_OPERATION_VALUE = "operation_value";
  326. public const string DT_OPERATION_VALUE = "nvarchar(255)";
  327. private String _operation_value;
  328. [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}")]
  329. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_condition.CN_REMARK); } }
  330. public const string CN_REMARK = "remark";
  331. public const string DT_REMARK = "nvarchar(255)";
  332. private String _remark;
  333. [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}")]
  334. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_condition.CN_STATUS_FLAG); } }
  335. public const string CN_STATUS_FLAG = "status_flag";
  336. public const string DT_STATUS_FLAG = "int";
  337. private int? _status_flag;
  338. public tb_rpt_report_condition() : base()
  339. {
  340. }
  341. }
  342. [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\"]}]}")]
  343. public class tb_rpt_report_mst : EntityBasicBase
  344. {
  345. public const string TABLENAME = "CHB_Report.tb_rpt_report_mst";
  346. [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}")]
  347. public String api_uid { get { return _api_uid;} set { _api_uid = value; SetDirty(tb_rpt_report_mst.CN_API_UID); } }
  348. public const string CN_API_UID = "api_uid";
  349. public const string DT_API_UID = "varchar(36)";
  350. private String _api_uid;
  351. [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}")]
  352. public String active_time { get { return _active_time;} set { _active_time = value; SetDirty(tb_rpt_report_mst.CN_ACTIVE_TIME); } }
  353. public const string CN_ACTIVE_TIME = "active_time";
  354. public const string DT_ACTIVE_TIME = "varchar(50)";
  355. private String _active_time;
  356. [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}")]
  357. public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_report_mst.CN_DATABASE_TYPE); } }
  358. public const string CN_DATABASE_TYPE = "database_type";
  359. public const string DT_DATABASE_TYPE = "varchar(16)";
  360. private String _database_type;
  361. [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}")]
  362. public String footer_img_path { get { return _footer_img_path;} set { _footer_img_path = value; SetDirty(tb_rpt_report_mst.CN_FOOTER_IMG_PATH); } }
  363. public const string CN_FOOTER_IMG_PATH = "footer_img_path";
  364. public const string DT_FOOTER_IMG_PATH = "nvarchar(255)";
  365. private String _footer_img_path;
  366. [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}")]
  367. public String header_img_path { get { return _header_img_path;} set { _header_img_path = value; SetDirty(tb_rpt_report_mst.CN_HEADER_IMG_PATH); } }
  368. public const string CN_HEADER_IMG_PATH = "header_img_path";
  369. public const string DT_HEADER_IMG_PATH = "nvarchar(255)";
  370. private String _header_img_path;
  371. [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}")]
  372. public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_report_mst.CN_MAIL); } }
  373. public const string CN_MAIL = "mail";
  374. public const string DT_MAIL = "nvarchar(255)";
  375. private String _mail;
  376. [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}")]
  377. public String name { get { return _name;} set { _name = value; SetDirty(tb_rpt_report_mst.CN_NAME); } }
  378. public const string CN_NAME = "name";
  379. public const string DT_NAME = "nvarchar(50)";
  380. private String _name;
  381. [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}")]
  382. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_mst.CN_REMARK); } }
  383. public const string CN_REMARK = "remark";
  384. public const string DT_REMARK = "nvarchar(255)";
  385. private String _remark;
  386. [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}")]
  387. public String schedule_frequency { get { return _schedule_frequency;} set { _schedule_frequency = value; SetDirty(tb_rpt_report_mst.CN_SCHEDULE_FREQUENCY); } }
  388. public const string CN_SCHEDULE_FREQUENCY = "schedule_frequency";
  389. public const string DT_SCHEDULE_FREQUENCY = "varchar(16)";
  390. private String _schedule_frequency;
  391. [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}")]
  392. public String server_group_name { get { return _server_group_name;} set { _server_group_name = value; SetDirty(tb_rpt_report_mst.CN_SERVER_GROUP_NAME); } }
  393. public const string CN_SERVER_GROUP_NAME = "server_group_name";
  394. public const string DT_SERVER_GROUP_NAME = "varchar(16)";
  395. private String _server_group_name;
  396. [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}")]
  397. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_mst.CN_STATUS_FLAG); } }
  398. public const string CN_STATUS_FLAG = "status_flag";
  399. public const string DT_STATUS_FLAG = "int";
  400. private int? _status_flag;
  401. public tb_rpt_report_mst() : base()
  402. {
  403. }
  404. }
  405. [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\"]}]}")]
  406. public class tb_rpt_report_schedule : EntityBasicBase
  407. {
  408. public const string TABLENAME = "CHB_Report.tb_rpt_report_schedule";
  409. [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}")]
  410. public String report_mst_uid { get { return _report_mst_uid;} set { _report_mst_uid = value; SetDirty(tb_rpt_report_schedule.CN_REPORT_MST_UID); } }
  411. public const string CN_REPORT_MST_UID = "report_mst_uid";
  412. public const string DT_REPORT_MST_UID = "varchar(36)";
  413. private String _report_mst_uid;
  414. [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}")]
  415. public DateTime? data_range_end { get { return _data_range_end;} set { _data_range_end = value; SetDirty(tb_rpt_report_schedule.CN_DATA_RANGE_END); } }
  416. public const string CN_DATA_RANGE_END = "data_range_end";
  417. public const string DT_DATA_RANGE_END = "datetime";
  418. private DateTime? _data_range_end;
  419. [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}")]
  420. public DateTime? data_range_start { get { return _data_range_start;} set { _data_range_start = value; SetDirty(tb_rpt_report_schedule.CN_DATA_RANGE_START); } }
  421. public const string CN_DATA_RANGE_START = "data_range_start";
  422. public const string DT_DATA_RANGE_START = "datetime";
  423. private DateTime? _data_range_start;
  424. [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}")]
  425. public String database_type { get { return _database_type;} set { _database_type = value; SetDirty(tb_rpt_report_schedule.CN_DATABASE_TYPE); } }
  426. public const string CN_DATABASE_TYPE = "database_type";
  427. public const string DT_DATABASE_TYPE = "varchar(16)";
  428. private String _database_type;
  429. [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}")]
  430. public DateTime? expected_date { get { return _expected_date;} set { _expected_date = value; SetDirty(tb_rpt_report_schedule.CN_EXPECTED_DATE); } }
  431. public const string CN_EXPECTED_DATE = "expected_date";
  432. public const string DT_EXPECTED_DATE = "datetime";
  433. private DateTime? _expected_date;
  434. [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}")]
  435. public String extension_meta { get { return _extension_meta;} set { _extension_meta = value; SetDirty(tb_rpt_report_schedule.CN_EXTENSION_META); } }
  436. public const string CN_EXTENSION_META = "extension_meta";
  437. public const string DT_EXTENSION_META = "nvarchar(255)";
  438. private String _extension_meta;
  439. [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}")]
  440. public int? handle_flag { get { return _handle_flag;} set { _handle_flag = value; SetDirty(tb_rpt_report_schedule.CN_HANDLE_FLAG); } }
  441. public const string CN_HANDLE_FLAG = "handle_flag";
  442. public const string DT_HANDLE_FLAG = "int";
  443. private int? _handle_flag;
  444. [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}")]
  445. public String ip { get { return _ip;} set { _ip = value; SetDirty(tb_rpt_report_schedule.CN_IP); } }
  446. public const string CN_IP = "ip";
  447. public const string DT_IP = "varchar(45)";
  448. private String _ip;
  449. [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}")]
  450. public String mail { get { return _mail;} set { _mail = value; SetDirty(tb_rpt_report_schedule.CN_MAIL); } }
  451. public const string CN_MAIL = "mail";
  452. public const string DT_MAIL = "nvarchar(255)";
  453. private String _mail;
  454. [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}")]
  455. public DateTime? process_date { get { return _process_date;} set { _process_date = value; SetDirty(tb_rpt_report_schedule.CN_PROCESS_DATE); } }
  456. public const string CN_PROCESS_DATE = "process_date";
  457. public const string DT_PROCESS_DATE = "datetime";
  458. private DateTime? _process_date;
  459. [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}")]
  460. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_rpt_report_schedule.CN_REMARK); } }
  461. public const string CN_REMARK = "remark";
  462. public const string DT_REMARK = "nvarchar(-1)";
  463. private String _remark;
  464. [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}")]
  465. public String server_group_name { get { return _server_group_name;} set { _server_group_name = value; SetDirty(tb_rpt_report_schedule.CN_SERVER_GROUP_NAME); } }
  466. public const string CN_SERVER_GROUP_NAME = "server_group_name";
  467. public const string DT_SERVER_GROUP_NAME = "varchar(16)";
  468. private String _server_group_name;
  469. [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}")]
  470. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_rpt_report_schedule.CN_STATUS_FLAG); } }
  471. public const string CN_STATUS_FLAG = "status_flag";
  472. public const string DT_STATUS_FLAG = "int";
  473. private int? _status_flag;
  474. public tb_rpt_report_schedule() : base()
  475. {
  476. }
  477. }
  478. [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\"]}]}")]
  479. public class tb_sys_action : EntityBasicBase
  480. {
  481. public const string TABLENAME = "CHB_Report.tb_sys_action";
  482. [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}")]
  483. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_action.CN_NAME); } }
  484. public const string CN_NAME = "name";
  485. public const string DT_NAME = "nvarchar(50)";
  486. private String _name;
  487. [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}")]
  488. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_action.CN_STATUS_FLAG); } }
  489. public const string CN_STATUS_FLAG = "status_flag";
  490. public const string DT_STATUS_FLAG = "int";
  491. private int? _status_flag;
  492. [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}")]
  493. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_action.CN_SYSTEM_FLAG); } }
  494. public const string CN_SYSTEM_FLAG = "system_flag";
  495. public const string DT_SYSTEM_FLAG = "int";
  496. private int? _system_flag;
  497. public tb_sys_action() : base()
  498. {
  499. }
  500. }
  501. [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\"]}]}")]
  502. public class tb_sys_adintegration : EntityBasicBase
  503. {
  504. public const string TABLENAME = "CHB_Report.tb_sys_adintegration";
  505. [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}")]
  506. public String file_path { get { return _file_path;} set { _file_path = value; SetDirty(tb_sys_adintegration.CN_FILE_PATH); } }
  507. public const string CN_FILE_PATH = "file_path";
  508. public const string DT_FILE_PATH = "nvarchar(255)";
  509. private String _file_path;
  510. [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}")]
  511. public String location { get { return _location;} set { _location = value; SetDirty(tb_sys_adintegration.CN_LOCATION); } }
  512. public const string CN_LOCATION = "location";
  513. public const string DT_LOCATION = "nvarchar(50)";
  514. private String _location;
  515. [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}")]
  516. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_adintegration.CN_REMARK); } }
  517. public const string CN_REMARK = "remark";
  518. public const string DT_REMARK = "nvarchar(50)";
  519. private String _remark;
  520. [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}")]
  521. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_adintegration.CN_STATUS_FLAG); } }
  522. public const string CN_STATUS_FLAG = "status_flag";
  523. public const string DT_STATUS_FLAG = "int";
  524. private int? _status_flag;
  525. public tb_sys_adintegration() : base()
  526. {
  527. }
  528. }
  529. [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\"]}]}")]
  530. public class tb_sys_adintegrationlog : EntityBase
  531. {
  532. public const string TABLENAME = "CHB_Report.tb_sys_adintegrationlog";
  533. [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}")]
  534. public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_ORG_UID); } }
  535. public const string CN_CREATE_ORG_UID = "create_org_uid";
  536. public const string DT_CREATE_ORG_UID = "varchar(36)";
  537. private String _create_org_uid;
  538. [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}")]
  539. public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_USER_UID); } }
  540. public const string CN_CREATE_USER_UID = "create_user_uid";
  541. public const string DT_CREATE_USER_UID = "varchar(36)";
  542. private String _create_user_uid;
  543. [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}")]
  544. public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_adintegrationlog.CN_CREATE_DATE); } }
  545. public const string CN_CREATE_DATE = "create_date";
  546. public const string DT_CREATE_DATE = "datetime";
  547. private DateTime? _create_date;
  548. [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}")]
  549. public String location { get { return _location;} set { _location = value; SetDirty(tb_sys_adintegrationlog.CN_LOCATION); } }
  550. public const string CN_LOCATION = "location";
  551. public const string DT_LOCATION = "nvarchar(50)";
  552. private String _location;
  553. [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}")]
  554. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_adintegrationlog.CN_REMARK); } }
  555. public const string CN_REMARK = "remark";
  556. public const string DT_REMARK = "nvarchar(-1)";
  557. private String _remark;
  558. [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}")]
  559. public int? success_flag { get { return _success_flag;} set { _success_flag = value; SetDirty(tb_sys_adintegrationlog.CN_SUCCESS_FLAG); } }
  560. public const string CN_SUCCESS_FLAG = "success_flag";
  561. public const string DT_SUCCESS_FLAG = "int";
  562. private int? _success_flag;
  563. [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}")]
  564. public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_adintegrationlog.CN_UID); } }
  565. public const string CN_UID = "uid";
  566. public const string DT_UID = "varchar(36)";
  567. private String _uid;
  568. public tb_sys_adintegrationlog() : base()
  569. {
  570. }
  571. }
  572. [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\"]}]}")]
  573. public class tb_sys_dblock : EntityBasicBase
  574. {
  575. public const string TABLENAME = "CHB_Report.tb_sys_dblock";
  576. [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}")]
  577. public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_dblock.CN_PROGRAM_UID); } }
  578. public const string CN_PROGRAM_UID = "program_uid";
  579. public const string DT_PROGRAM_UID = "varchar(36)";
  580. private String _program_uid;
  581. [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}")]
  582. public String lock_cust_desc { get { return _lock_cust_desc;} set { _lock_cust_desc = value; SetDirty(tb_sys_dblock.CN_LOCK_CUST_DESC); } }
  583. public const string CN_LOCK_CUST_DESC = "lock_cust_desc";
  584. public const string DT_LOCK_CUST_DESC = "nvarchar(50)";
  585. private String _lock_cust_desc;
  586. [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}")]
  587. public String lock_hostname { get { return _lock_hostname;} set { _lock_hostname = value; SetDirty(tb_sys_dblock.CN_LOCK_HOSTNAME); } }
  588. public const string CN_LOCK_HOSTNAME = "lock_hostname";
  589. public const string DT_LOCK_HOSTNAME = "nvarchar(50)";
  590. private String _lock_hostname;
  591. [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}")]
  592. public String lock_ip { get { return _lock_ip;} set { _lock_ip = value; SetDirty(tb_sys_dblock.CN_LOCK_IP); } }
  593. public const string CN_LOCK_IP = "lock_ip";
  594. public const string DT_LOCK_IP = "varchar(39)";
  595. private String _lock_ip;
  596. [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}")]
  597. public String lock_uid { get { return _lock_uid;} set { _lock_uid = value; SetDirty(tb_sys_dblock.CN_LOCK_UID); } }
  598. public const string CN_LOCK_UID = "lock_uid";
  599. public const string DT_LOCK_UID = "varchar(36)";
  600. private String _lock_uid;
  601. [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}")]
  602. public DateTime? lock_update_date { get { return _lock_update_date;} set { _lock_update_date = value; SetDirty(tb_sys_dblock.CN_LOCK_UPDATE_DATE); } }
  603. public const string CN_LOCK_UPDATE_DATE = "lock_update_date";
  604. public const string DT_LOCK_UPDATE_DATE = "datetime";
  605. private DateTime? _lock_update_date;
  606. [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}")]
  607. 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); } }
  608. public const string CN_LOCK_UPDATE_ORG_UID = "lock_update_org_uid";
  609. public const string DT_LOCK_UPDATE_ORG_UID = "varchar(36)";
  610. private String _lock_update_org_uid;
  611. [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}")]
  612. 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); } }
  613. public const string CN_LOCK_UPDATE_USER_UID = "lock_update_user_uid";
  614. public const string DT_LOCK_UPDATE_USER_UID = "varchar(36)";
  615. private String _lock_update_user_uid;
  616. [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}")]
  617. public String table_uid { get { return _table_uid;} set { _table_uid = value; SetDirty(tb_sys_dblock.CN_TABLE_UID); } }
  618. public const string CN_TABLE_UID = "table_uid";
  619. public const string DT_TABLE_UID = "nvarchar(50)";
  620. private String _table_uid;
  621. public tb_sys_dblock() : base()
  622. {
  623. }
  624. }
  625. [TableMisc("{\"SOURCE_SQL\":\"MSSQL\",\"TABLE_CATALOG\":\"CHB_Report\",\"TABLE_NAME\":\"tb_sys_exceptionlog\",\"PKColumns\":[],\"ForeignRelations\":{},\"UniqueIndexes\":[{\"Item1\":\"UQ__tb_sys_o__DD701265C9BE813D\",\"Item2\":[\"uid\"]}]}")]
  626. public class tb_sys_exceptionlog : EntityBase
  627. {
  628. public const string TABLENAME = "CHB_Report.tb_sys_exceptionlog";
  629. [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}")]
  630. public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_DATE); } }
  631. public const string CN_CREATE_DATE = "create_date";
  632. public const string DT_CREATE_DATE = "datetime";
  633. private DateTime? _create_date;
  634. [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}")]
  635. public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_ORG_UID); } }
  636. public const string CN_CREATE_ORG_UID = "create_org_uid";
  637. public const string DT_CREATE_ORG_UID = "varchar(36)";
  638. private String _create_org_uid;
  639. [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}")]
  640. public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_exceptionlog.CN_CREATE_USER_UID); } }
  641. public const string CN_CREATE_USER_UID = "create_user_uid";
  642. public const string DT_CREATE_USER_UID = "varchar(36)";
  643. private String _create_user_uid;
  644. [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}")]
  645. public String detail { get { return _detail;} set { _detail = value; SetDirty(tb_sys_exceptionlog.CN_DETAIL); } }
  646. public const string CN_DETAIL = "detail";
  647. public const string DT_DETAIL = "nvarchar(-1)";
  648. private String _detail;
  649. [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}")]
  650. public String file_path { get { return _file_path;} set { _file_path = value; SetDirty(tb_sys_exceptionlog.CN_FILE_PATH); } }
  651. public const string CN_FILE_PATH = "file_path";
  652. public const string DT_FILE_PATH = "nvarchar(255)";
  653. private String _file_path;
  654. [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}")]
  655. public int? line_number { get { return _line_number;} set { _line_number = value; SetDirty(tb_sys_exceptionlog.CN_LINE_NUMBER); } }
  656. public const string CN_LINE_NUMBER = "line_number";
  657. public const string DT_LINE_NUMBER = "int";
  658. private int? _line_number;
  659. [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}")]
  660. public String member_name { get { return _member_name;} set { _member_name = value; SetDirty(tb_sys_exceptionlog.CN_MEMBER_NAME); } }
  661. public const string CN_MEMBER_NAME = "member_name";
  662. public const string DT_MEMBER_NAME = "nvarchar(255)";
  663. private String _member_name;
  664. [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}")]
  665. public String parameters { get { return _parameters;} set { _parameters = value; SetDirty(tb_sys_exceptionlog.CN_PARAMETERS); } }
  666. public const string CN_PARAMETERS = "parameters";
  667. public const string DT_PARAMETERS = "nvarchar(-1)";
  668. private String _parameters;
  669. [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}")]
  670. public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_exceptionlog.CN_PROGRAM_UID); } }
  671. public const string CN_PROGRAM_UID = "program_uid";
  672. public const string DT_PROGRAM_UID = "varchar(36)";
  673. private String _program_uid;
  674. [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}")]
  675. public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_exceptionlog.CN_UID); } }
  676. public const string CN_UID = "uid";
  677. public const string DT_UID = "varchar(36)";
  678. private String _uid;
  679. public tb_sys_exceptionlog() : base()
  680. {
  681. }
  682. }
  683. [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\"]}]}")]
  684. public class tb_sys_manuallog : EntityBase
  685. {
  686. public const string TABLENAME = "CHB_Report.tb_sys_manuallog";
  687. [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}")]
  688. public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_manuallog.CN_CREATE_ORG_UID); } }
  689. public const string CN_CREATE_ORG_UID = "create_org_uid";
  690. public const string DT_CREATE_ORG_UID = "varchar(36)";
  691. private String _create_org_uid;
  692. [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}")]
  693. public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_manuallog.CN_CREATE_USER_UID); } }
  694. public const string CN_CREATE_USER_UID = "create_user_uid";
  695. public const string DT_CREATE_USER_UID = "varchar(36)";
  696. private String _create_user_uid;
  697. [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}")]
  698. public String action_name { get { return _action_name;} set { _action_name = value; SetDirty(tb_sys_manuallog.CN_ACTION_NAME); } }
  699. public const string CN_ACTION_NAME = "action_name";
  700. public const string DT_ACTION_NAME = "nvarchar(16)";
  701. private String _action_name;
  702. [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}")]
  703. public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_manuallog.CN_CREATE_DATE); } }
  704. public const string CN_CREATE_DATE = "create_date";
  705. public const string DT_CREATE_DATE = "datetime";
  706. private DateTime? _create_date;
  707. [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}")]
  708. public String message { get { return _message;} set { _message = value; SetDirty(tb_sys_manuallog.CN_MESSAGE); } }
  709. public const string CN_MESSAGE = "message";
  710. public const string DT_MESSAGE = "nvarchar(-1)";
  711. private String _message;
  712. [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}")]
  713. public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_manuallog.CN_PROGRAM_UID); } }
  714. public const string CN_PROGRAM_UID = "program_uid";
  715. public const string DT_PROGRAM_UID = "varchar(36)";
  716. private String _program_uid;
  717. [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}")]
  718. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_manuallog.CN_REMARK); } }
  719. public const string CN_REMARK = "remark";
  720. public const string DT_REMARK = "nvarchar(-1)";
  721. private String _remark;
  722. [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}")]
  723. public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_manuallog.CN_UID); } }
  724. public const string CN_UID = "uid";
  725. public const string DT_UID = "varchar(36)";
  726. private String _uid;
  727. public tb_sys_manuallog() : base()
  728. {
  729. }
  730. }
  731. [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\"]}]}")]
  732. public class tb_sys_module : EntityBasicBase
  733. {
  734. public const string TABLENAME = "CHB_Report.tb_sys_module";
  735. [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}")]
  736. public String parent { get { return _parent;} set { _parent = value; SetDirty(tb_sys_module.CN_PARENT); } }
  737. public const string CN_PARENT = "parent";
  738. public const string DT_PARENT = "varchar(36)";
  739. private String _parent;
  740. [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}")]
  741. public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_module.CN_CODE); } }
  742. public const string CN_CODE = "code";
  743. public const string DT_CODE = "nvarchar(50)";
  744. private String _code;
  745. [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}")]
  746. public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_module.CN_MEMO); } }
  747. public const string CN_MEMO = "memo";
  748. public const string DT_MEMO = "nvarchar(255)";
  749. private String _memo;
  750. [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}")]
  751. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_module.CN_NAME); } }
  752. public const string CN_NAME = "name";
  753. public const string DT_NAME = "nvarchar(50)";
  754. private String _name;
  755. [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}")]
  756. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_module.CN_REMARK); } }
  757. public const string CN_REMARK = "remark";
  758. public const string DT_REMARK = "nvarchar(50)";
  759. private String _remark;
  760. [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}")]
  761. public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_module.CN_SEQ); } }
  762. public const string CN_SEQ = "seq";
  763. public const string DT_SEQ = "int";
  764. private int? _seq;
  765. [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}")]
  766. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_module.CN_STATUS_FLAG); } }
  767. public const string CN_STATUS_FLAG = "status_flag";
  768. public const string DT_STATUS_FLAG = "int";
  769. private int? _status_flag;
  770. public tb_sys_module() : base()
  771. {
  772. }
  773. }
  774. [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\"]}]}")]
  775. public class tb_sys_org : EntityBasicBase
  776. {
  777. public const string TABLENAME = "CHB_Report.tb_sys_org";
  778. [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}")]
  779. public String email { get { return _email;} set { _email = value; SetDirty(tb_sys_org.CN_EMAIL); } }
  780. public const string CN_EMAIL = "email";
  781. public const string DT_EMAIL = "varchar(320)";
  782. private String _email;
  783. [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}")]
  784. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_org.CN_NAME); } }
  785. public const string CN_NAME = "name";
  786. public const string DT_NAME = "nvarchar(50)";
  787. private String _name;
  788. [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}")]
  789. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_org.CN_STATUS_FLAG); } }
  790. public const string CN_STATUS_FLAG = "status_flag";
  791. public const string DT_STATUS_FLAG = "int";
  792. private int? _status_flag;
  793. public tb_sys_org() : base()
  794. {
  795. }
  796. }
  797. [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\"]}]}")]
  798. public class tb_sys_param : EntityBasicBase
  799. {
  800. public const string TABLENAME = "CHB_Report.tb_sys_param";
  801. [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}")]
  802. public String paramcatalog { get { return _paramcatalog;} set { _paramcatalog = value; SetDirty(tb_sys_param.CN_PARAMCATALOG); } }
  803. public const string CN_PARAMCATALOG = "paramcatalog";
  804. public const string DT_PARAMCATALOG = "varchar(36)";
  805. private String _paramcatalog;
  806. [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}")]
  807. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_param.CN_NAME); } }
  808. public const string CN_NAME = "name";
  809. public const string DT_NAME = "nvarchar(50)";
  810. private String _name;
  811. [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}")]
  812. public String param_value { get { return _param_value;} set { _param_value = value; SetDirty(tb_sys_param.CN_PARAM_VALUE); } }
  813. public const string CN_PARAM_VALUE = "param_value";
  814. public const string DT_PARAM_VALUE = "nvarchar(50)";
  815. private String _param_value;
  816. [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}")]
  817. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_param.CN_REMARK); } }
  818. public const string CN_REMARK = "remark";
  819. public const string DT_REMARK = "nvarchar(50)";
  820. private String _remark;
  821. [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}")]
  822. public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_param.CN_SEQ); } }
  823. public const string CN_SEQ = "seq";
  824. public const string DT_SEQ = "int";
  825. private int? _seq;
  826. [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}")]
  827. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_param.CN_STATUS_FLAG); } }
  828. public const string CN_STATUS_FLAG = "status_flag";
  829. public const string DT_STATUS_FLAG = "int";
  830. private int? _status_flag;
  831. [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}")]
  832. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_param.CN_SYSTEM_FLAG); } }
  833. public const string CN_SYSTEM_FLAG = "system_flag";
  834. public const string DT_SYSTEM_FLAG = "int";
  835. private int? _system_flag;
  836. public tb_sys_param() : base()
  837. {
  838. }
  839. }
  840. [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\"]}]}")]
  841. public class tb_sys_paramcatalog : EntityBasicBase
  842. {
  843. public const string TABLENAME = "CHB_Report.tb_sys_paramcatalog";
  844. [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}")]
  845. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_paramcatalog.CN_NAME); } }
  846. public const string CN_NAME = "name";
  847. public const string DT_NAME = "nvarchar(50)";
  848. private String _name;
  849. [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}")]
  850. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_paramcatalog.CN_REMARK); } }
  851. public const string CN_REMARK = "remark";
  852. public const string DT_REMARK = "nvarchar(50)";
  853. private String _remark;
  854. [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}")]
  855. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_paramcatalog.CN_STATUS_FLAG); } }
  856. public const string CN_STATUS_FLAG = "status_flag";
  857. public const string DT_STATUS_FLAG = "int";
  858. private int? _status_flag;
  859. [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}")]
  860. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_paramcatalog.CN_SYSTEM_FLAG); } }
  861. public const string CN_SYSTEM_FLAG = "system_flag";
  862. public const string DT_SYSTEM_FLAG = "int";
  863. private int? _system_flag;
  864. public tb_sys_paramcatalog() : base()
  865. {
  866. }
  867. }
  868. [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\"]}]}")]
  869. public class tb_sys_program : EntityBasicBase
  870. {
  871. public const string TABLENAME = "CHB_Report.tb_sys_program";
  872. [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}")]
  873. public String module_uid { get { return _module_uid;} set { _module_uid = value; SetDirty(tb_sys_program.CN_MODULE_UID); } }
  874. public const string CN_MODULE_UID = "module_uid";
  875. public const string DT_MODULE_UID = "varchar(36)";
  876. private String _module_uid;
  877. [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}")]
  878. public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_program.CN_CODE); } }
  879. public const string CN_CODE = "code";
  880. public const string DT_CODE = "nvarchar(50)";
  881. private String _code;
  882. [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}")]
  883. public String icon { get { return _icon;} set { _icon = value; SetDirty(tb_sys_program.CN_ICON); } }
  884. public const string CN_ICON = "icon";
  885. public const string DT_ICON = "nchar(20)";
  886. private String _icon;
  887. [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}")]
  888. public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_program.CN_MEMO); } }
  889. public const string CN_MEMO = "memo";
  890. public const string DT_MEMO = "nvarchar(255)";
  891. private String _memo;
  892. [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}")]
  893. public String menudisplay { get { return _menudisplay;} set { _menudisplay = value; SetDirty(tb_sys_program.CN_MENUDISPLAY); } }
  894. public const string CN_MENUDISPLAY = "menudisplay";
  895. public const string DT_MENUDISPLAY = "char(1)";
  896. private String _menudisplay;
  897. [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}")]
  898. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_program.CN_NAME); } }
  899. public const string CN_NAME = "name";
  900. public const string DT_NAME = "nvarchar(50)";
  901. private String _name;
  902. [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}")]
  903. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_program.CN_REMARK); } }
  904. public const string CN_REMARK = "remark";
  905. public const string DT_REMARK = "nvarchar(50)";
  906. private String _remark;
  907. [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}")]
  908. public String rout_path { get { return _rout_path;} set { _rout_path = value; SetDirty(tb_sys_program.CN_ROUT_PATH); } }
  909. public const string CN_ROUT_PATH = "rout_path";
  910. public const string DT_ROUT_PATH = "nvarchar(255)";
  911. private String _rout_path;
  912. [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}")]
  913. public int? seq { get { return _seq;} set { _seq = value; SetDirty(tb_sys_program.CN_SEQ); } }
  914. public const string CN_SEQ = "seq";
  915. public const string DT_SEQ = "int";
  916. private int? _seq;
  917. [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}")]
  918. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program.CN_STATUS_FLAG); } }
  919. public const string CN_STATUS_FLAG = "status_flag";
  920. public const string DT_STATUS_FLAG = "int";
  921. private int? _status_flag;
  922. public tb_sys_program() : base()
  923. {
  924. }
  925. }
  926. [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\"]}]}")]
  927. public class tb_sys_program2action : EntityBasicBase
  928. {
  929. public const string TABLENAME = "CHB_Report.tb_sys_program2action";
  930. [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}")]
  931. public String program_uid { get { return _program_uid;} set { _program_uid = value; SetDirty(tb_sys_program2action.CN_PROGRAM_UID); } }
  932. public const string CN_PROGRAM_UID = "program_uid";
  933. public const string DT_PROGRAM_UID = "varchar(36)";
  934. private String _program_uid;
  935. [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}")]
  936. public String action_name { get { return _action_name;} set { _action_name = value; SetDirty(tb_sys_program2action.CN_ACTION_NAME); } }
  937. public const string CN_ACTION_NAME = "action_name";
  938. public const string DT_ACTION_NAME = "nvarchar(50)";
  939. private String _action_name;
  940. [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}")]
  941. public int? sequence { get { return _sequence;} set { _sequence = value; SetDirty(tb_sys_program2action.CN_SEQUENCE); } }
  942. public const string CN_SEQUENCE = "sequence";
  943. public const string DT_SEQUENCE = "int";
  944. private int? _sequence;
  945. [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}")]
  946. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program2action.CN_STATUS_FLAG); } }
  947. public const string CN_STATUS_FLAG = "status_flag";
  948. public const string DT_STATUS_FLAG = "int";
  949. private int? _status_flag;
  950. public tb_sys_program2action() : base()
  951. {
  952. }
  953. }
  954. [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\"]}]}")]
  955. public class tb_sys_program2action_grant : EntityBasicBase
  956. {
  957. public const string TABLENAME = "CHB_Report.tb_sys_program2action_grant";
  958. [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}")]
  959. public String program2action_uid { get { return _program2action_uid;} set { _program2action_uid = value; SetDirty(tb_sys_program2action_grant.CN_PROGRAM2ACTION_UID); } }
  960. public const string CN_PROGRAM2ACTION_UID = "program2action_uid";
  961. public const string DT_PROGRAM2ACTION_UID = "varchar(36)";
  962. private String _program2action_uid;
  963. [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}")]
  964. public String grant_type { get { return _grant_type;} set { _grant_type = value; SetDirty(tb_sys_program2action_grant.CN_GRANT_TYPE); } }
  965. public const string CN_GRANT_TYPE = "grant_type";
  966. public const string DT_GRANT_TYPE = "varchar(36)";
  967. private String _grant_type;
  968. [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}")]
  969. public String grant_uid { get { return _grant_uid;} set { _grant_uid = value; SetDirty(tb_sys_program2action_grant.CN_GRANT_UID); } }
  970. public const string CN_GRANT_UID = "grant_uid";
  971. public const string DT_GRANT_UID = "varchar(36)";
  972. private String _grant_uid;
  973. [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}")]
  974. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_program2action_grant.CN_STATUS_FLAG); } }
  975. public const string CN_STATUS_FLAG = "status_flag";
  976. public const string DT_STATUS_FLAG = "int";
  977. private int? _status_flag;
  978. public tb_sys_program2action_grant() : base()
  979. {
  980. }
  981. }
  982. [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\"]}]}")]
  983. public class tb_sys_role : EntityBasicBase
  984. {
  985. public const string TABLENAME = "CHB_Report.tb_sys_role";
  986. [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}")]
  987. public String code { get { return _code;} set { _code = value; SetDirty(tb_sys_role.CN_CODE); } }
  988. public const string CN_CODE = "code";
  989. public const string DT_CODE = "nvarchar(50)";
  990. private String _code;
  991. [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}")]
  992. public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_role.CN_MEMO); } }
  993. public const string CN_MEMO = "memo";
  994. public const string DT_MEMO = "nvarchar(255)";
  995. private String _memo;
  996. [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}")]
  997. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_role.CN_NAME); } }
  998. public const string CN_NAME = "name";
  999. public const string DT_NAME = "nvarchar(50)";
  1000. private String _name;
  1001. [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}")]
  1002. public String remark { get { return _remark;} set { _remark = value; SetDirty(tb_sys_role.CN_REMARK); } }
  1003. public const string CN_REMARK = "remark";
  1004. public const string DT_REMARK = "nvarchar(50)";
  1005. private String _remark;
  1006. [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}")]
  1007. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_role.CN_STATUS_FLAG); } }
  1008. public const string CN_STATUS_FLAG = "status_flag";
  1009. public const string DT_STATUS_FLAG = "int";
  1010. private int? _status_flag;
  1011. [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}")]
  1012. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_role.CN_SYSTEM_FLAG); } }
  1013. public const string CN_SYSTEM_FLAG = "system_flag";
  1014. public const string DT_SYSTEM_FLAG = "int";
  1015. private int? _system_flag;
  1016. public tb_sys_role() : base()
  1017. {
  1018. }
  1019. }
  1020. [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\"]}]}")]
  1021. public class tb_sys_role2org : EntityBasicBase
  1022. {
  1023. public const string TABLENAME = "CHB_Report.tb_sys_role2org";
  1024. [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}")]
  1025. public String org_uid { get { return _org_uid;} set { _org_uid = value; SetDirty(tb_sys_role2org.CN_ORG_UID); } }
  1026. public const string CN_ORG_UID = "org_uid";
  1027. public const string DT_ORG_UID = "varchar(36)";
  1028. private String _org_uid;
  1029. [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}")]
  1030. public String role_uid { get { return _role_uid;} set { _role_uid = value; SetDirty(tb_sys_role2org.CN_ROLE_UID); } }
  1031. public const string CN_ROLE_UID = "role_uid";
  1032. public const string DT_ROLE_UID = "varchar(36)";
  1033. private String _role_uid;
  1034. [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}")]
  1035. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_role2org.CN_STATUS_FLAG); } }
  1036. public const string CN_STATUS_FLAG = "status_flag";
  1037. public const string DT_STATUS_FLAG = "int";
  1038. private int? _status_flag;
  1039. public tb_sys_role2org() : base()
  1040. {
  1041. }
  1042. }
  1043. [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\"]}]}")]
  1044. public class tb_sys_session : EntityBasicBase
  1045. {
  1046. public const string TABLENAME = "CHB_Report.tb_sys_session";
  1047. [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}")]
  1048. public String role_name { get { return _role_name;} set { _role_name = value; SetDirty(tb_sys_session.CN_ROLE_NAME); } }
  1049. public const string CN_ROLE_NAME = "role_name";
  1050. public const string DT_ROLE_NAME = "nvarchar(50)";
  1051. private String _role_name;
  1052. public tb_sys_session() : base()
  1053. {
  1054. }
  1055. }
  1056. [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\"]}]}")]
  1057. public class tb_sys_system_setting : EntityBasicBase
  1058. {
  1059. public const string TABLENAME = "CHB_Report.tb_sys_system_setting";
  1060. [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}")]
  1061. public String key_value { get { return _key_value;} set { _key_value = value; SetDirty(tb_sys_system_setting.CN_KEY_VALUE); } }
  1062. public const string CN_KEY_VALUE = "key_value";
  1063. public const string DT_KEY_VALUE = "nvarchar(255)";
  1064. private String _key_value;
  1065. [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}")]
  1066. public String memo { get { return _memo;} set { _memo = value; SetDirty(tb_sys_system_setting.CN_MEMO); } }
  1067. public const string CN_MEMO = "memo";
  1068. public const string DT_MEMO = "nvarchar(50)";
  1069. private String _memo;
  1070. [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}")]
  1071. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_system_setting.CN_NAME); } }
  1072. public const string CN_NAME = "name";
  1073. public const string DT_NAME = "nvarchar(20)";
  1074. private String _name;
  1075. [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}")]
  1076. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_system_setting.CN_STATUS_FLAG); } }
  1077. public const string CN_STATUS_FLAG = "status_flag";
  1078. public const string DT_STATUS_FLAG = "int";
  1079. private int? _status_flag;
  1080. [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}")]
  1081. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_system_setting.CN_SYSTEM_FLAG); } }
  1082. public const string CN_SYSTEM_FLAG = "system_flag";
  1083. public const string DT_SYSTEM_FLAG = "int";
  1084. private int? _system_flag;
  1085. public tb_sys_system_setting() : base()
  1086. {
  1087. }
  1088. }
  1089. [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\"]}]}")]
  1090. public class tb_sys_translation : EntityBasicBase
  1091. {
  1092. public const string TABLENAME = "CHB_Report.tb_sys_translation";
  1093. [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}")]
  1094. public String language { get { return _language;} set { _language = value; SetDirty(tb_sys_translation.CN_LANGUAGE); } }
  1095. public const string CN_LANGUAGE = "language";
  1096. public const string DT_LANGUAGE = "nvarchar(10)";
  1097. private String _language;
  1098. [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}")]
  1099. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_translation.CN_NAME); } }
  1100. public const string CN_NAME = "name";
  1101. public const string DT_NAME = "nvarchar(50)";
  1102. private String _name;
  1103. [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}")]
  1104. public String trans { get { return _trans;} set { _trans = value; SetDirty(tb_sys_translation.CN_TRANS); } }
  1105. public const string CN_TRANS = "trans";
  1106. public const string DT_TRANS = "nvarchar(30)";
  1107. private String _trans;
  1108. public tb_sys_translation() : base()
  1109. {
  1110. }
  1111. }
  1112. [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\"]}]}")]
  1113. public class tb_sys_uploadlog : EntityBasicBase
  1114. {
  1115. public const string TABLENAME = "CHB_Report.tb_sys_uploadlog";
  1116. [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}")]
  1117. public String module { get { return _module;} set { _module = value; SetDirty(tb_sys_uploadlog.CN_MODULE); } }
  1118. public const string CN_MODULE = "module";
  1119. public const string DT_MODULE = "nvarchar(32)";
  1120. private String _module;
  1121. [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}")]
  1122. public String name { get { return _name;} set { _name = value; SetDirty(tb_sys_uploadlog.CN_NAME); } }
  1123. public const string CN_NAME = "name";
  1124. public const string DT_NAME = "nvarchar(64)";
  1125. private String _name;
  1126. [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}")]
  1127. public String path { get { return _path;} set { _path = value; SetDirty(tb_sys_uploadlog.CN_PATH); } }
  1128. public const string CN_PATH = "path";
  1129. public const string DT_PATH = "nvarchar(255)";
  1130. private String _path;
  1131. [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}")]
  1132. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_uploadlog.CN_STATUS_FLAG); } }
  1133. public const string CN_STATUS_FLAG = "status_flag";
  1134. public const string DT_STATUS_FLAG = "int";
  1135. private int? _status_flag;
  1136. public tb_sys_uploadlog() : base()
  1137. {
  1138. }
  1139. }
  1140. [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\"]}]}")]
  1141. public class tb_sys_user : EntityBasicBase
  1142. {
  1143. public const string TABLENAME = "CHB_Report.tb_sys_user";
  1144. [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}")]
  1145. public String account { get { return _account;} set { _account = value; SetDirty(tb_sys_user.CN_ACCOUNT); } }
  1146. public const string CN_ACCOUNT = "account";
  1147. public const string DT_ACCOUNT = "nvarchar(50)";
  1148. private String _account;
  1149. [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}")]
  1150. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_user.CN_STATUS_FLAG); } }
  1151. public const string CN_STATUS_FLAG = "status_flag";
  1152. public const string DT_STATUS_FLAG = "int";
  1153. private int? _status_flag;
  1154. [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}")]
  1155. public int? system_flag { get { return _system_flag;} set { _system_flag = value; SetDirty(tb_sys_user.CN_SYSTEM_FLAG); } }
  1156. public const string CN_SYSTEM_FLAG = "system_flag";
  1157. public const string DT_SYSTEM_FLAG = "int";
  1158. private int? _system_flag;
  1159. public tb_sys_user() : base()
  1160. {
  1161. }
  1162. }
  1163. [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\"]}]}")]
  1164. public class tb_sys_user2entercode : EntityBase
  1165. {
  1166. public const string TABLENAME = "CHB_Report.tb_sys_user2entercode";
  1167. [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}")]
  1168. public String create_org_uid { get { return _create_org_uid;} set { _create_org_uid = value; SetDirty(tb_sys_user2entercode.CN_CREATE_ORG_UID); } }
  1169. public const string CN_CREATE_ORG_UID = "create_org_uid";
  1170. public const string DT_CREATE_ORG_UID = "varchar(36)";
  1171. private String _create_org_uid;
  1172. [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}")]
  1173. public String create_user_uid { get { return _create_user_uid;} set { _create_user_uid = value; SetDirty(tb_sys_user2entercode.CN_CREATE_USER_UID); } }
  1174. public const string CN_CREATE_USER_UID = "create_user_uid";
  1175. public const string DT_CREATE_USER_UID = "varchar(36)";
  1176. private String _create_user_uid;
  1177. [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}")]
  1178. public String user_uid { get { return _user_uid;} set { _user_uid = value; SetDirty(tb_sys_user2entercode.CN_USER_UID); } }
  1179. public const string CN_USER_UID = "user_uid";
  1180. public const string DT_USER_UID = "varchar(36)";
  1181. private String _user_uid;
  1182. [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}")]
  1183. public DateTime? create_date { get { return _create_date;} set { _create_date = value; SetDirty(tb_sys_user2entercode.CN_CREATE_DATE); } }
  1184. public const string CN_CREATE_DATE = "create_date";
  1185. public const string DT_CREATE_DATE = "datetime";
  1186. private DateTime? _create_date;
  1187. [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}")]
  1188. public String uid { get { return _uid;} set { _uid = value; SetDirty(tb_sys_user2entercode.CN_UID); } }
  1189. public const string CN_UID = "uid";
  1190. public const string DT_UID = "varchar(36)";
  1191. private String _uid;
  1192. [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}")]
  1193. public String user_entercode { get { return _user_entercode;} set { _user_entercode = value; SetDirty(tb_sys_user2entercode.CN_USER_ENTERCODE); } }
  1194. public const string CN_USER_ENTERCODE = "user_entercode";
  1195. public const string DT_USER_ENTERCODE = "varchar(256)";
  1196. private String _user_entercode;
  1197. public tb_sys_user2entercode() : base()
  1198. {
  1199. }
  1200. }
  1201. [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\"]}]}")]
  1202. public class tb_sys_user2role : EntityBasicBase
  1203. {
  1204. public const string TABLENAME = "CHB_Report.tb_sys_user2role";
  1205. [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}")]
  1206. public String role_uid { get { return _role_uid;} set { _role_uid = value; SetDirty(tb_sys_user2role.CN_ROLE_UID); } }
  1207. public const string CN_ROLE_UID = "role_uid";
  1208. public const string DT_ROLE_UID = "varchar(36)";
  1209. private String _role_uid;
  1210. [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}")]
  1211. public String user_uid { get { return _user_uid;} set { _user_uid = value; SetDirty(tb_sys_user2role.CN_USER_UID); } }
  1212. public const string CN_USER_UID = "user_uid";
  1213. public const string DT_USER_UID = "varchar(36)";
  1214. private String _user_uid;
  1215. [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}")]
  1216. public String isdefault { get { return _isdefault;} set { _isdefault = value; SetDirty(tb_sys_user2role.CN_ISDEFAULT); } }
  1217. public const string CN_ISDEFAULT = "isdefault";
  1218. public const string DT_ISDEFAULT = "char(1)";
  1219. private String _isdefault;
  1220. [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}")]
  1221. public int? status_flag { get { return _status_flag;} set { _status_flag = value; SetDirty(tb_sys_user2role.CN_STATUS_FLAG); } }
  1222. public const string CN_STATUS_FLAG = "status_flag";
  1223. public const string DT_STATUS_FLAG = "int";
  1224. private int? _status_flag;
  1225. public tb_sys_user2role() : base()
  1226. {
  1227. }
  1228. }