gs01

Tables (3)

Company

  • company_id (id) — INT — Primary key — NOT NULL

Group

  • group_id (id) — INT — Primary key — NOT NULL
  • group_number — VARCHAR(5) — Primary key — NOT NULL
  • company_id — INT — Foreign key → Company.company_id — NOT NULL
  • default — Boolean

User

  • user_id (id) — INT — Primary key — NOT NULL
  • company_id — INT — Foreign key → Company.company_id — NOT NULL
  • group_number — VARCHAR(5) — Foreign key → Group.group_number — NOT NULL
  • login_id — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(255)
  • phone_number — INT(11)