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