권한관리
테이블 (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