[yocto] webhob: DB design

[Lv, ChunhuaX]

hi everyone,
here are webhob database design.
webhob database include 14 tables:
db_role, db_operator, db_systemConfig, db_settings, db_layers, db_history,
db_builds, db_group, db_project, db_images, db_permissions,db_build_logs,
db_mgt_bitbake_servers, db_build_temp

tables list
<1>table: db_builds
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

build's name

project_id

int

foreign key

operator_id

int

foreign key

size

int

image's size

image_id

int

foreign key

is_buildComplete

boolean

build's result (true/false)

valid

boolean

valid

create_date

datetime

create_date

  <2> table: db_group
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

group's name

creator

varchar(100)

creator

operator__id

int

foreign key

valid

boolean

valid

create_date

datetime

create_date

  <3>table:db_history
Name

Fieldtype

Note

id

int

primary key

message

text

message

operator_id

int

foreign key

project_id

int

foreign key

valid

boolean

valid

create_date

datetime

create_date

  <4>table:db_images
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

image's name

size

int

image's size

url

varchar(100)

download url

valid

boolean

valid

create_date

datetime

create_date

  <5>table: db_layers
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

layer's name

types

varchar(50)

layer's type (core layer/user's layer)

project_id

int

foreign key

create_date

datetime

create_date

  <6>table:db_operator
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

operator's name

password

varchar(100)

login password

role__id

int

foreign key

email

varchar(100)

login username

valid

boolean

valid

create_date

datetime

create_date

  <7>table:db_permissions
Name

Fieldtype

Note

id

int

primary key

project_id

int

foreign key

group_id

int

foreign key

operator_id

int

foreign key

system_config_id

int

foreign key

valid

boolean

valid

create_date

datetime

create_date

  <8>table:db_project
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

project's name

valid

boolean

valid

creator

varchar(100)

creator

create_date

datetime

create_date

operator__id

int

foreign key

group__id

int

foreign key

  <9>table:db_role
Name

Fieldtype

Note

id

int

primary key

name

varchar(100)

role's name

valid

boolean

valid

create_date

datetime

create_date

  <10>table:db_settings
Name

Fieldtype

Note

id

int

primary key

image_types

text

image_types

package_formats

varchar(100)

package_formats

image_rootfs_size

int

image_rootfs_size

image_extra_size

int

image_extra_size

gplv3_checkbox

varchar(50)

gplv3_checkbox's value

build_toolchain_checkbox

boolean

build_toolchain is checked

build_toolchain_value

varchar(50)

build_toolchain's value

distro

varchar(50)

distro

project_id

int

foreign key

is_template

boolean

settings config is saved as a template

valid

boolean

valid

create_date

datetime

create_date

  <11>table:db_systemConfig
Name

Fieldtype

Note

id

int

primary key

types

varchar(100)

types (distro,pkg format,image type,build toolchain)

name

varchar(100)

name

valid

boolean

valid

create_date

datetime

create_date

  <12>table:db_build_logs
Name

Fieldtype

Note

id

int

primary key

guid

varchar(100)

global unique id (user_name + project_name + build_name + timerstamp)

build_task

varchar(100)

current task (parse recipe/build pkg or image)

valid

boolean

valid

create_date

datetime

create_date

operator__id

int

foreign key

project_id

int

foreign key

  <13>table:db_mgt_bitbake_servers
Name

Fieldtype

Note

id

int

primary key

ip

varchar(200)

bitbake machine ip

port

int(5)

bitbake port

status

varchar(200)

status(free, busy,down)

status_code

int(5)

1:free 2: busy 3:down

error_msg

varchar(1000)

error message note

  <14>table:db_build_temp
Name

Fieldtype

Note

id

int

primary key

guid

varchar(100)

global unique id

build_content

text

store build info(such as bitbake, setting config, recipe/pkg treemodel)

valid

boolean

valid

every feedback is very welcome.

thanks
chunhua

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/yocto/attachments/20120713/ad2815b8/attachment.html>