php登录与数据库设计,php – 与数据库模式和设计相关

我认为@Uours位于正确的页面上,但我建议采用稍微不同的方法,允许您定义一次属性,然后在各种页面上使用它们.就像是：

page_types

page_type_id (PK)

page_type_name (e.g. College, College & University, University, Hospital, Company, ...)

page_attributes

page_attribute_id (PK)

page_attribute_name (e.g. Name, Address, City, Country, Email, ...)

page_attribute_input_type (e.g. text, checkbox, date, email, password, radio, textarea, select, ...)

page_attribute_input_options (e.g. list of values, size=, maxlength=, pattern=, ...)

page_type_attributes

page_id (PK, FK)

page_attribute_id (PK, FK)

page_attribute_sequence (PK)

page_type_attribute_label (defaults to page_attribute_name but can be overriden in case the same attribute is used more than once on a page)

users

user_id (PK)

user_name

...

user_pages

user_page_id (PK)

user_id (FK)

user_page_type_id (FK)

user_page_name (What the user calls this page)

user_page_attributes

user_page_attribute_id (PK)

user_id (FK)

user_page_id (FK)

page_attribute_id (FK)

user_page_attribute_value

祝好运.希望这可以帮助.