M.I.O
Tables (4)
menu (Untitled3)
- system_id (시스템 아이디) — VARCHAR(100) — Primary key — NOT NULL
- menu_code (메뉴코드) — VARCHAR(100) — Primary key — NOT NULL
role (역할)
- system_id (시스템 아이디) — VARCHAR(100) — Primary key — NOT NULL — PK
- role_code (역할코드) — VARCHAR2(200) — Primary key — NOT NULL — PK
- role_name (역할이름(띄울때)) — VARCHAR(100) — NOT NULL
- description (비고) — VARCHAR(100)
role_menu (Untitled2)
- system_id (시스템 아이디) — VARCHAR(100) — Foreign key → role.system_id — NOT NULL — PK, FK
- role_code (역할코드) — VARCHAR2(200) — Foreign key → role.role_code — NOT NULL — PK,FK
- menu_code (메뉴코드) — VARCHAR(100) — Foreign key → menu.menu_code — NOT NULL
whole_member (모든인원)
- system_id (시스템아이디) — VARCHAR(100) — Primary key — NOT NULL — PK
- member_id (학생아이디) — VARCHAR(100) — Primary key — NOT NULL — PK
- role_code (역할코드) — VARCHAR2(200) — Foreign key → role.role_code — NOT NULL — FK
- password (비밀번호) — VARCHAR(200) — NOT NULL
- user_name (학생이름) — VARCHAR(100)
- Field