I'm a newbie at d3.js and need help to adapt Zoomable Sunburst to make it work with self-referencing CSV data. Sample lines from the input CSV: id,parentId,name,size ROOT,NULL,Root, RE,ROOT,Genera...

I want to define a model that has a self-referential (or recursive) foreign key using SQLModel. (This relationship pattern is also sometimes referred to as an adjacency list.) The pure SQLAlchemy i...

I have set up a self referential entity using EF Core which looks like this: Entity public class DetailType { public int DetailTypeId { get; set; } public string Name { get; set; } public int...

I have the table with one primary key and one foreign key referencing the same table primary key. i.e there are parents and childs in the same table. In sql sever there are three options for the d...

I've table with four columns id, name, designation, manager_id. Table schema: CREATE TABLE "Employee_Information" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "designa...

Database Table: I tried this approach to map the category table to EF core: protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.Entity<Category>(entity => ...

I have a table that references itself, but I am struggling with getting my desired mapping. I want to be able to define Children to be a collection of people that have a given person as Mother, Fat...

I was asked how I would create a hibernate mapping for a column in a table that refers to the primary key of the table. For example, an Employee table has EMP_ID as primary key and it also has MG...

I am trying to model bidirectional parent-child design, with ordered children. When removing child (eg. child #2 of 3 children) from the parent, hibernate's generated sql led to unique constraint...

Sorry if this is a stupid question, but I'm a bit of a Django newbie and can't find the answer. I have an Order model with a self-referencing field: source = models.ForeignKey( 'self', help_tex...

I want to represent a self referencing table in a text tree (like TreeView but in text). I have been working on it and I did good so far. The problem is when I go few levels deep in the tree. So fa...

Consider the following requirement for building a forum App Parent Post - Child Post1 - Child Post1-1 - Child Post1-2 - Child Post1-2-1 - Child Post2 - Child Post - Child Post3 Table Stru...