support
Tables (5)
group
- group_id — varchar — Primary key — NOT NULL
- group_name — varchar
- description — varchar
- status — int
- display_seq — int
- created — time
- modified — time
page
- page_id — varchar — Primary key — NOT NULL
- page_name — varchar
- description — varchar
- page_url — varchar
- type — int
- display_seq — int
- parent_page_id — varchar
- status — int
- created — time
- modified — time
page_group
- group_id — varchar — Foreign key → group.group_id — NOT NULL
- page_id — varchar — Foreign key → page.page_id — NOT NULL
user
- user_id — varchar — Primary key — NOT NULL
- email — varchar
- user_name — varchar
- sso_key — varchar
- user_password — varchar
- created — time
- modified — time
- status — int
user_page_group
- group_id — varchar — Foreign key → group.group_id — NOT NULL
- user_id — varchar — Foreign key → user.user_id — NOT NULL