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)