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)