FICO-ADMIN

Tables (5)

bookmark (Untitled)

    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