TEST_ERD

Tables (3)

company (회사)

  • company_id (아이디) — num — Primary key — NOT NULL
  • name (이름) — varchar2

group_number (그룹넘버)

  • group_number_id (아이디) — num — Primary key — NOT NULL
  • group_number (그룹넘버) — varchar2
  • company_id (회사아이디) — num — Foreign key → company.company_id — NOT NULL

user (유저)

  • id (아이디) — num — Primary key — NOT NULL
  • Field
  • group_number_id (아이디3) — num — Foreign key → group_number.group_number_id — NOT NULL
  • company_id (아이디2) — num — Foreign key → company.company_id — NOT NULL