Skip to end of metadata
Go to start of metadata
Table of Contents

This page provides a reference database schema (in PostgreSQL \d output format) for all CAS components that have a database implementation.

JpaTicketRegistry

ticketgrantingticket
               Table "public.ticketgrantingticket"
           Column           |          Type          | Modifiers 
----------------------------+------------------------+-----------
 id                         | character varying(255) | not null
 number_of_times_used       | integer                | 
 creation_time              | bigint                 | 
 expiration_policy          | oid                    | not null
 last_time_used             | bigint                 | 
 previous_last_time_used    | bigint                 | 
 authentication             | oid                    | not null
 expired                    | boolean                | not null
 services_granted_access_to | oid                    | not null
 ticketgrantingticket_id    | character varying(255) | 
Indexes:
    "ticketgrantingticket_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "fkb4c4cdde32a2c0e5" FOREIGN KEY (ticketgrantingticket_id) REFERENCES ticketgrantingticket(id)
Referenced by:
    TABLE "serviceticket" CONSTRAINT "fk7645ade132a2c0e5" FOREIGN KEY (ticketgrantingticket_id) REFERENCES ticketgrantingticket(id)
    TABLE "ticketgrantingticket" CONSTRAINT "fkb4c4cdde32a2c0e5" FOREIGN KEY (ticketgrantingticket_id) REFERENCES ticketgrantingticket(id)
serviceticket
                 Table "public.serviceticket"
         Column          |          Type          | Modifiers 
-------------------------+------------------------+-----------
 id                      | character varying(255) | not null
 number_of_times_used    | integer                | 
 creation_time           | bigint                 | 
 expiration_policy       | oid                    | not null
 last_time_used          | bigint                 | 
 previous_last_time_used | bigint                 | 
 from_new_login          | boolean                | not null
 ticket_already_granted  | boolean                | not null
 service                 | oid                    | not null
 ticketgrantingticket_id | character varying(255) | 
Indexes:
    "serviceticket_pkey" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "fk7645ade132a2c0e5" FOREIGN KEY (ticketgrantingticket_id) REFERENCES ticketgrantingticket(id)

JpaLockingStrategy

                   Table "public.locks"
     Column      |            Type             | Modifiers 
-----------------+-----------------------------+-----------
 application_id  | character varying(255)      | not null
 expiration_date | timestamp without time zone | 
 unique_id       | character varying(255)      | 
Indexes:
    "locks_pkey" PRIMARY KEY, btree (application_id)

JpaServiceRegistryDaoImpl

registeredserviceimpl
                         Table "public.registeredserviceimpl"
      Column      |          Type          |                 Modifiers                 
------------------+------------------------+-------------------------------------------
 expression_type  | character varying(15)  | not null default 'ant'::character varying
 id               | bigint                 | not null
 allowedtoproxy   | boolean                | not null
 anonymousaccess  | boolean                | not null
 description      | character varying(255) | 
 enabled          | boolean                | not null
 evaluation_order | integer                | not null
 ignoreattributes | boolean                | not null
 name             | character varying(255) | 
 serviceid        | character varying(255) | 
 ssoenabled       | boolean                | not null
 theme            | character varying(255) | 
 username_attr    | character varying(256) | 
Indexes:
    "registeredserviceimpl_pkey" PRIMARY KEY, btree (id)
Referenced by:
    TABLE "rs_attributes" CONSTRAINT "fk4322e153c595e1f" FOREIGN KEY (registeredserviceimpl_id) REFERENCES registeredserviceimpl(id)
rs_attributes
                 Table "public.rs_attributes"
          Column          |          Type          | Modifiers 
--------------------------+------------------------+-----------
 registeredserviceimpl_id | bigint                 | not null
 a_name                   | character varying(255) | not null
 a_id                     | integer                | not null
Indexes:
    "rs_attributes_pkey" PRIMARY KEY, btree (registeredserviceimpl_id, a_id)
Foreign-key constraints:
    "fk4322e153c595e1f" FOREIGN KEY (registeredserviceimpl_id) REFERENCES registeredserviceimpl(id)

JdbcAuditTrailManager (Inspektr Auditing)

             Table "public.com_audit_trail"
    Column     |            Type             | Modifiers 
---------------+-----------------------------+-----------
 aud_user      | character varying(100)      | not null
 aud_client_ip | character varying(15)       | not null
 aud_server_ip | character varying(15)       | not null
 aud_resource  | character varying(100)      | not null
 aud_action    | character varying(100)      | not null
 applic_cd     | character varying(5)        | not null
 aud_date      | timestamp without time zone | not null
Indexes:
    "pk_com_audit_trail" PRIMARY KEY, btree (aud_user, aud_client_ip, aud_server_ip, aud_resource, aud_action, applic_cd, aud_date)
    "i_com_audit_trail" btree (aud_date)
    "i_com_audit_trail_action_date" btree (aud_action, aud_date)
    "i_com_audit_trail_client_date" btree (aud_client_ip, aud_date)
    "i_com_audit_trail_resource_date" btree (aud_resource, aud_date)
    "i_com_audit_trail_user_date" btree (aud_user, aud_date)
  • No labels