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.
208 lines
24 KiB
208 lines
24 KiB
[TableMisc("{\"TABLE_CATALOG\":\"odb_generic\",\"TABLE_NAME\":\"otb_role\",\"PKColumns\":[\"guid\"],\"ForeignRelations\":{\"FK_tb_role_tb_user_create_user\":{\"Pars\":{\"create_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"},\"FK_tb_role_tb_user_modify_user\":{\"Pars\":{\"modify_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"}}}")]
|
|
public class otb_role : EntityBase
|
|
{
|
|
public const string TABLENAME = "otb_role";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"guid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"PK_tb_role\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":true,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String guid { get { return _guid;} set { _guid = value; SetDirty(otb_role.CN_GUID); } }
|
|
public const string CN_GUID = "guid";
|
|
public const string DT_GUID = "char(36)";
|
|
private String _guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"create_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_tb_role_tb_user_create_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_guid { get { return _create_user_guid;} set { _create_user_guid = value; SetDirty(otb_role.CN_CREATE_USER_GUID); } }
|
|
public const string CN_CREATE_USER_GUID = "create_user_guid";
|
|
public const string DT_CREATE_USER_GUID = "char(36)";
|
|
private String _create_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_tb_role_tb_user_modify_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String modify_user_guid { get { return _modify_user_guid;} set { _modify_user_guid = value; SetDirty(otb_role.CN_MODIFY_USER_GUID); } }
|
|
public const string CN_MODIFY_USER_GUID = "modify_user_guid";
|
|
public const string DT_MODIFY_USER_GUID = "char(36)";
|
|
private String _modify_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"active_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"('Y')\",\"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,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String active_flag { get { return _active_flag;} set { _active_flag = value; SetDirty(otb_role.CN_ACTIVE_FLAG); } }
|
|
public const string CN_ACTIVE_FLAG = "active_flag";
|
|
public const string DT_ACTIVE_FLAG = "char(1)";
|
|
private String _active_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime create_date { get { return _create_date;} set { _create_date = value; SetDirty(otb_role.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime modify_date { get { return _modify_date;} set { _modify_date = value; SetDirty(otb_role.CN_MODIFY_DATE); } }
|
|
public const string CN_MODIFY_DATE = "modify_date";
|
|
public const string DT_MODIFY_DATE = "datetime";
|
|
private DateTime _modify_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_role\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"role_id\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"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,\"IsRequireFill\":false,\"DataType\":\"varchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String role_id { get { return _role_id;} set { _role_id = value; SetDirty(otb_role.CN_ROLE_ID); } }
|
|
public const string CN_ROLE_ID = "role_id";
|
|
public const string DT_ROLE_ID = "varchar(16)";
|
|
private String _role_id;
|
|
|
|
|
|
public otb_role() : base()
|
|
{
|
|
this.PKNames.Add(otb_role.CN_GUID);
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"TABLE_CATALOG\":\"odb_generic\",\"TABLE_NAME\":\"otb_user\",\"PKColumns\":[\"guid\"],\"ForeignRelations\":{\"FK_tb_user_tb_role\":{\"Pars\":{\"role_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_role\"},\"FK_tb_user_tb_user_create_user\":{\"Pars\":{\"create_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"},\"FK_tb_user_tb_user_modify_user\":{\"Pars\":{\"modify_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"}}}")]
|
|
public class otb_user : EntityBase
|
|
{
|
|
public const string TABLENAME = "otb_user";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"guid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"PK_tb_user\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":true,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String guid { get { return _guid;} set { _guid = value; SetDirty(otb_user.CN_GUID); } }
|
|
public const string CN_GUID = "guid";
|
|
public const string DT_GUID = "char(36)";
|
|
private String _guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"role_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_role\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_tb_user_tb_role\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String role_guid { get { return _role_guid;} set { _role_guid = value; SetDirty(otb_user.CN_ROLE_GUID); } }
|
|
public const string CN_ROLE_GUID = "role_guid";
|
|
public const string DT_ROLE_GUID = "char(36)";
|
|
private String _role_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"create_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_tb_user_tb_user_create_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_guid { get { return _create_user_guid;} set { _create_user_guid = value; SetDirty(otb_user.CN_CREATE_USER_GUID); } }
|
|
public const string CN_CREATE_USER_GUID = "create_user_guid";
|
|
public const string DT_CREATE_USER_GUID = "char(36)";
|
|
private String _create_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_tb_user_tb_user_modify_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String modify_user_guid { get { return _modify_user_guid;} set { _modify_user_guid = value; SetDirty(otb_user.CN_MODIFY_USER_GUID); } }
|
|
public const string CN_MODIFY_USER_GUID = "modify_user_guid";
|
|
public const string DT_MODIFY_USER_GUID = "char(36)";
|
|
private String _modify_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"active_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"('Y')\",\"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,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String active_flag { get { return _active_flag;} set { _active_flag = value; SetDirty(otb_user.CN_ACTIVE_FLAG); } }
|
|
public const string CN_ACTIVE_FLAG = "active_flag";
|
|
public const string DT_ACTIVE_FLAG = "char(1)";
|
|
private String _active_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime create_date { get { return _create_date;} set { _create_date = value; SetDirty(otb_user.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"email\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":64,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"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,\"IsRequireFill\":false,\"DataType\":\"varchar(64)\",\"DescriptionExtension\":null}")]
|
|
public String email { get { return _email;} set { _email = value; SetDirty(otb_user.CN_EMAIL); } }
|
|
public const string CN_EMAIL = "email";
|
|
public const string DT_EMAIL = "varchar(64)";
|
|
private String _email;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"mobile\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"CHARACTER_MAXIMUM_LENGTH\":15,\"COLUMN_DEFAULT\":null,\"DESCRIPTION\":\"\",\"IsUnique\":false,\"IndexName\":null,\"IsRequire\":false,\"IsNullable\":true,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":15,\"IsPK\":false,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"varchar(15)\",\"DescriptionExtension\":null}")]
|
|
public String mobile { get { return _mobile;} set { _mobile = value; SetDirty(otb_user.CN_MOBILE); } }
|
|
public const string CN_MOBILE = "mobile";
|
|
public const string DT_MOBILE = "varchar(15)";
|
|
private String _mobile;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime modify_date { get { return _modify_date;} set { _modify_date = value; SetDirty(otb_user.CN_MODIFY_DATE); } }
|
|
public const string CN_MODIFY_DATE = "modify_date";
|
|
public const string DT_MODIFY_DATE = "datetime";
|
|
private DateTime _modify_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"tel\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"varchar\",\"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,\"IsRequireFill\":false,\"DataType\":\"varchar(20)\",\"DescriptionExtension\":null}")]
|
|
public String tel { get { return _tel;} set { _tel = value; SetDirty(otb_user.CN_TEL); } }
|
|
public const string CN_TEL = "tel";
|
|
public const string DT_TEL = "varchar(20)";
|
|
private String _tel;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"user_id\",\"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,\"IsRequireFill\":true,\"DataType\":\"nvarchar(16)\",\"DescriptionExtension\":null}")]
|
|
public String user_id { get { return _user_id;} set { _user_id = value; SetDirty(otb_user.CN_USER_ID); } }
|
|
public const string CN_USER_ID = "user_id";
|
|
public const string DT_USER_ID = "nvarchar(16)";
|
|
private String _user_id;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_user\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"user_name\",\"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,\"IsRequireFill\":false,\"DataType\":\"nvarchar(32)\",\"DescriptionExtension\":null}")]
|
|
public String user_name { get { return _user_name;} set { _user_name = value; SetDirty(otb_user.CN_USER_NAME); } }
|
|
public const string CN_USER_NAME = "user_name";
|
|
public const string DT_USER_NAME = "nvarchar(32)";
|
|
private String _user_name;
|
|
|
|
|
|
public otb_user() : base()
|
|
{
|
|
this.PKNames.Add(otb_user.CN_GUID);
|
|
}
|
|
}
|
|
|
|
[TableMisc("{\"TABLE_CATALOG\":\"odb_generic\",\"TABLE_NAME\":\"otb_session\",\"PKColumns\":[\"guid\"],\"ForeignRelations\":{\"FK_otb_session_tb_user_create_user\":{\"Pars\":{\"create_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"},\"FK_otb_session_tb_user_modify_user\":{\"Pars\":{\"modify_user_guid\":\"guid\"},\"ForeignDisplayColumns\":[],\"ForeignTable\":\"otb_user\"}}}")]
|
|
public class otb_session : EntityBase
|
|
{
|
|
public const string TABLENAME = "otb_session";
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"guid\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":36,\"COLUMN_DEFAULT\":\"(newid())\",\"DESCRIPTION\":\"\",\"IsUnique\":true,\"IndexName\":\"PK_otb_session\",\"IsRequire\":false,\"IsNullable\":false,\"IsString\":true,\"IsNumber\":false,\"MaxLength\":36,\"IsPK\":true,\"IsFK\":false,\"PK_Table\":null,\"PK_Column\":null,\"CONSTRAINT_NAME\":null,\"DELETE_RULE\":null,\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String guid { get { return _guid;} set { _guid = value; SetDirty(otb_session.CN_GUID); } }
|
|
public const string CN_GUID = "guid";
|
|
public const string DT_GUID = "char(36)";
|
|
private String _guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"create_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_otb_session_tb_user_create_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String create_user_guid { get { return _create_user_guid;} set { _create_user_guid = value; SetDirty(otb_session.CN_CREATE_USER_GUID); } }
|
|
public const string CN_CREATE_USER_GUID = "create_user_guid";
|
|
public const string DT_CREATE_USER_GUID = "char(36)";
|
|
private String _create_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_user_guid\",\"IS_NULLABLE\":\"YES\",\"DATA_TYPE\":\"char\",\"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\":\"otb_user\",\"PK_Column\":\"guid\",\"CONSTRAINT_NAME\":\"FK_otb_session_tb_user_modify_user\",\"DELETE_RULE\":\"NO ACTION\",\"IDENT_SEED\":-1.0,\"IDENT_INCR\":-1.0,\"NUMERIC_PRECISION\":0,\"NUMERIC_SCALE\":0,\"IsRequireFill\":false,\"DataType\":\"char(36)\",\"DescriptionExtension\":null}")]
|
|
public String modify_user_guid { get { return _modify_user_guid;} set { _modify_user_guid = value; SetDirty(otb_session.CN_MODIFY_USER_GUID); } }
|
|
public const string CN_MODIFY_USER_GUID = "modify_user_guid";
|
|
public const string DT_MODIFY_USER_GUID = "char(36)";
|
|
private String _modify_user_guid;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"active_flag\",\"IS_NULLABLE\":\"NO\",\"DATA_TYPE\":\"char\",\"CHARACTER_MAXIMUM_LENGTH\":1,\"COLUMN_DEFAULT\":\"('Y')\",\"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,\"IsRequireFill\":false,\"DataType\":\"char(1)\",\"DescriptionExtension\":null}")]
|
|
public String active_flag { get { return _active_flag;} set { _active_flag = value; SetDirty(otb_session.CN_ACTIVE_FLAG); } }
|
|
public const string CN_ACTIVE_FLAG = "active_flag";
|
|
public const string DT_ACTIVE_FLAG = "char(1)";
|
|
private String _active_flag;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime create_date { get { return _create_date;} set { _create_date = value; SetDirty(otb_session.CN_CREATE_DATE); } }
|
|
public const string CN_CREATE_DATE = "create_date";
|
|
public const string DT_CREATE_DATE = "datetime";
|
|
private DateTime _create_date;
|
|
|
|
|
|
[ColumnMiscAttribute("{\"TABLE_NAME\":\"otb_session\",\"TABLE_CATALOG\":\"odb_generic\",\"COLUMN_NAME\":\"modify_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,\"IsRequireFill\":false,\"DataType\":\"datetime\",\"DescriptionExtension\":null}")]
|
|
public DateTime modify_date { get { return _modify_date;} set { _modify_date = value; SetDirty(otb_session.CN_MODIFY_DATE); } }
|
|
public const string CN_MODIFY_DATE = "modify_date";
|
|
public const string DT_MODIFY_DATE = "datetime";
|
|
private DateTime _modify_date;
|
|
|
|
|
|
public otb_session() : base()
|
|
{
|
|
this.PKNames.Add(otb_session.CN_GUID);
|
|
}
|
|
}
|
|
|