persist

type Author struct {
	Id   sql.NullInt32 `d3:"pk:auto"`
	Name string
}

type Book struct {
	Id      sql.NullInt32      `d3:"pk:auto"`
	Authors *entity.Collection `d3:"many_to_many:<target_entity:Author,join_on:book_id,reference_on:author_id,join_table:book_author_p>,type:lazy"`
	Name    string
}

type SellerCirc struct {
	Id   sql.NullInt32 `d3:"pk:auto"`
	Name string

	CurrentShop *entity.Cell       `d3:"one_to_one:<target_entity:ShopCirc,join_on:shop_id>,type:lazy"`
	KnownShops  *entity.Collection `d3:"many_to_many:<target_entity:ShopCirc,join_on:seller_id,reference_on:shop_id,join_table:known_shop_seller_c>,type:lazy"`
}

type Shop struct {
	Id      sql.NullInt32      `d3:"pk:auto"`
	Books   *entity.Collection `d3:"one_to_many:<target_entity:Book,join_on:shop_id,delete:nullable>,type:lazy"`
	Profile *entity.Cell       `d3:"one_to_one:<target_entity:ShopProfile,join_on:profile_id,delete:cascade>,type:lazy"`
	Name    string
}

type ShopCirc struct {
	Id   sql.NullInt32 `d3:"pk:auto"`
	Name string

	Profile *entity.Cell `d3:"one_to_one:<target_entity:ShopProfileCirc,join_on:profile_id>,type:lazy"`

	FriendShop *entity.Cell `d3:"one_to_one:<target_entity:ShopCirc,join_on:friend_id>,type:lazy"`

	TopSeller    *entity.Cell       `d3:"one_to_one:<target_entity:SellerCirc,join_on:top_seller_id>,type:lazy"`
	Sellers      *entity.Collection `d3:"one_to_many:<target_entity:SellerCirc,join_on:shop_id>,type:lazy"`
	KnownSellers *entity.Collection `d3:"many_to_many:<target_entity:SellerCirc,join_on:shop_id,reference_on:seller_id,join_table:known_shop_seller_c>,type:lazy"`
}

type ShopProfile struct {
	Id          sql.NullInt32 `d3:"pk:auto"`
	Description string
}

type ShopProfileCirc struct {
	Id          sql.NullInt32 `d3:"pk:auto"`
	Shop        *entity.Cell  `d3:"one_to_one:<target_entity:ShopCirc,join_on:shop_id>,type:lazy"`
	Description string
}