FICO-ADMIN
Tables (5)
page (페이지정보)
- id — long — Primary key — NOT NULL
- type — String
- key — String
- name — String
- page — String
role (권한을 지정할 수 있는 목록)
- id — long — Primary key — NOT NULL
- role_name (roleName) — String
- authority — String
user_collection_auth (사용자 별 수정 가능한 collection 정보)
- id — long — Primary key — NOT NULL
- user_id (userId) — long — Foreign key → users.id — NOT NULL
- collection_id (collectionId) — long
users (사용자 정보)
- id — long — Primary key — NOT NULL
- user_id (userId) — String
- password — String
- email — String
- index_page (indexPage) — String
- fwk_role (fwkRole) — long
- sch_role (schRole) — long
- api_role (apiRole) — long
- modified_date (modifiedDate) — String
- avatar — String