권한관리

테이블 (5)

empandrole (Untitled4)

  • Key — 기본 키 — NOT NULL
  • promission_id (Key2) — 외래 키 → promission.promission_id — NOT NULL
  • employe_id (Key3) — 외래 키 → employe_role.employe_id — NOT NULL
  • insert (Field)
  • deket (Field2)
  • update (Field3)

employe_role (Untitled2)

  • employe_id (Key) — 기본 키 — NOT NULL
  • role_name (Field)
  • role_rank (Field2)

member (Untitled)

  • member_id (Key) — 기본 키 — NOT NULL
  • employe_id (Key2) — 외래 키 → employe_role.employe_id — NOT NULL

permissionandrole (CopyOfUntitled)

  • permissionandrole_id (Key) — 기본 키 — NOT NULL
  • member_id (Key3) — 외래 키 → promission.promission_id — NOT NULL
  • promission_id (Key2) — 외래 키 → member.member_id — NOT NULL
  • insert (Field)
  • delete (Field2)
  • update (Field3)

promission (Untitled3)

  • promission_id (Key) — 기본 키 — NOT NULL