Albalog
Tables (9)
authorization (Untitled3)
- Key — Primary key — NOT NULL
company (Untitled5)
- company_id (Key) — Primary key — NOT NULL
- employer_id (Field)
- name (Field2)
employee (Untitled)
- employee_id (Key) — Primary key — NOT NULL
- user_id (유저 id) — Foreign key → user.user_id — NOT NULL
employee_and_company (Untitled6)
- employee_id (Key) — Primary key — NOT NULL
- company_id (Key2) — Primary key — NOT NULL
employee_company_salary (Untitled7)
- employee_id (Key) — Primary key — NOT NULL
- company_id (Key2) — Primary key — NOT NULL
- salary (Field)
employer (Untitled2)
- employer_id (Key) — Primary key — NOT NULL
- user_id (유저 id) — Foreign key → user.user_id — NOT NULL
- gst_number (Field)
gst_number (Untitled8)
- Key — Primary key — NOT NULL
- Field
- employer_id (Key2) — Foreign key → employer.employer_id — NOT NULL
- user_id (유저 id) — Foreign key → employer.user_id — NOT NULL
position (Untitled4)
- position_id (Key) — Primary key — NOT NULL
- company (Field)
user (유저)
- user_id (유저 id) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- name (Field3)
- nickname (Field4)
- phone_number (Field5)