某表的设计如下
CREATE TABLE dbo.EOS_DICT_TYPE
(
DICTTYPEID VARCHAR (128) NOT NULL,
DICTTYPENAME VARCHAR (255) NULL,
RANK INT NULL,
PARENTID VARCHAR (255) NULL,
SEQNO VARCHAR (255) NULL,
PRIMARY KEY (DICTTYPEID)
)
部分数据如下
DICTTYPEID DICTTYPENAME RANK PARENTID SEQNO
city City 3 province .country.province.city.
country Country 1 .country.
province Province 2 country .country.province.
很多树形表都喜欢采用这种方式来设计,尤其是SEQNO列采用如上方式存数据,请问这样做有什么好处吗?
CREATE TABLE dbo.EOS_DICT_TYPE
(
DICTTYPEID VARCHAR (128) NOT NULL,
DICTTYPENAME VARCHAR (255) NULL,
RANK INT NULL,
PARENTID VARCHAR (255) NULL,
SEQNO VARCHAR (255) NULL,
PRIMARY KEY (DICTTYPEID)
)
部分数据如下
DICTTYPEID DICTTYPENAME RANK PARENTID SEQNO
city City 3 province .country.province.city.
country Country 1 .country.
province Province 2 country .country.province.
很多树形表都喜欢采用这种方式来设计,尤其是SEQNO列采用如上方式存数据,请问这样做有什么好处吗?
city|| City|| 3|| province|| .country.province.city. ||
country|| Country|| 1|| ||空|| .country. ||
province|| Province|| 2|| country|| .country.province. ||