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