check-constraints
Check constraint to validate IP address field
I\'m working on a project involving C# and开发者_StackOverflow中文版 a SQL Server 2008 database.[详细]
2023-01-09 15:16 分类:问答How to find the entity with the greatest primary key?
I\'ve an entity LearningUnit that has an int primary key. Actually, it has nothing more. Entity Concept has the following relationship with it:[详细]
2022-12-31 06:07 分类:问答Ensure Oracle row represents a unique timespan
I have to make a process in Oracle/PLSQL. I have to verify that the interval of time between start_date and end_date from a new row that I create must not intersect other start_dates and end_dates fro[详细]
2022-12-31 05:58 分类:问答SQL Server Constraints Across Tables
I have a SQL Server database with an Apartment table (which has columns FloorNum and BuildingID) and an ApartmentBuilding table (with column NumFloors). Is there any w开发者_如何学编程ay to set up a c[详细]
2022-12-29 01:58 分类:问答How to specify the cardinality of a @OneToMany in EclipseLink/JPA
I\'m trying to impose a @Oneto7 association. I\'d have imagined an attribute that specifies the target many value, but have found none.[详细]
2022-12-27 21:04 分类:问答SQL CHECK constraint issues
I\'m using SQL Server 20开发者_开发技巧08 and I have a table with three columns: Length, StartTime and EndTime. I want to make a CHECK constraint on this table which says that:[详细]
2022-12-26 21:21 分类:问答How do I create a multiple-table check constraint?
Please imagine this small database... Diagram removed dead ImageSha开发者_Go百科ck link - volunteer database diagram[详细]
2022-12-26 01:56 分类:问答Is it possible to a db constraint in for this rule?
I wish to make sure that my data has a constraint the following check (constraint?) in place This table can only have one BorderColour per hub/category. (eg. #FFAABB)[详细]
2022-12-24 13:02 分类:问答One check constraint or multiple check constraints?
Any suggestions on whether fewer check constraints are better, or more?How should they be grouped if at all?[详细]
2022-12-23 06:44 分类:问答How to add Check Constraints for Django Model fields?
While subclassing db.models.Model, s开发者_Python百科ometimes it\'s essential to add extra checks/constraints.[详细]
2022-12-20 05:43 分类:问答