mjcs Database

TABLES 89

COLUMNS 1064

Constraints 118

Anomalies 20

Routines 0

Database Properties

Database Type: PostgreSQL - 11.10

Schema public

standard public schema

Tables

Table / View	Children	Parents	Columns	Rows	Type
odycrim_services	0	1	6	50003	Table
odycivil_judgment_comments	0	1	48	7907	Table
dscr_bail_events	0	1	10	23228	Table
odycrim_attorneys	0	3	15	117031	Table
odycivil_involved_parties	2	1	13	13846	Table
scrapes	0	2	6	921678	Table
odycivil_cause_remedies	0	2	6	7956	Table
odycivil_aliases	0	3	6	537	Table
odytraf_involved_parties	2	1	14	594648	Table
dsk8_related_persons	0	1	14	15654	Table
dscr_defendants	0	1	14	22773	Table
odytraf_aliases	0	3	6	51757	Table
alembic_version	0	0	1	1	Table
odycrim_charges	0	1	38	255821	Table
odytraf_warrants	0	1	8	10106	Table
dsk8_defendant_aliases	0	1	8	1642	Table
cc_party_addresses	0	4	9	34433	Table
odycivil_dispositions	0	1	11	1	Table
odytraf_reference_numbers	0	1	4	942510	Table
dscr_defendant_aliases	0	1	8	485	Table
cc_party_alias	0	4	6	765	Table
cc_documents	0	1	13	50472	Table
odycrim_bond_settings	0	1	6	76507	Table
dscivil_trials	0	1	10	4533	Table
odycivil_defendants	2	1	14	8236	Table
odycivil_reference_numbers	0	1	4	671	Table
dscr_events	0	1	6	86237	Table
odycivil_court_schedule	0	1	10	133	Table
cc_judgments	3	1	17	94	Table
dscr_related_persons	0	1	14	55478	Table
odytraf_court_schedule	0	1	10	336658	Table
dscr	7	1	12	22773	Table
odycivil_services	0	1	6	14105	Table
cc_judgments_against	0	2	4	234	Table
cc_district_case_numbers	0	2	3	595	Table
odycivil_documents	0	1	7	151423	Table
odycrim_reference_numbers	0	1	4	113329	Table
dscivil_judgments	0	2	28	14529	Table
odycrim_documents	0	1	6	1280821	Table
dscivil_hearings	0	2	11	2501	Table
cc_judgment_modifications	0	2	13	5	Table
dscivil	6	1	9	40167	Table
dscivil_events	0	1	7	473446	Table
odycivil_attorneys	0	3	15	5756	Table
cc_judgments_in_favor	0	2	4	0	Table
dsk8_bail_and_bond	1	1	23	483	Table
dscr_trials	0	1	10	7933	Table
dsk8	8	2	13	3054	Table
odycrim_involved_parties	2	1	14	210280	Table
odytraf_defendants	2	1	14	294799	Table
odycivil_bond_settings	0	1	6	1	Table
odytraf_bond_settings	0	1	6	17214	Table
dsk8_charges	0	1	33	15083	Table
odycivil_judgments	1	1	29	8101	Table
cc_related_persons	3	1	6	12148	Table
cc_plaintiffs	3	1	6	8436	Table
cc_attorneys	0	4	16	14703	Table
odycrim_court_schedule	0	1	10	184105	Table
odytraf_documents	0	1	7	873428	Table
odycrim_probation	0	1	14	8230	Table
odycrim_restitutions	0	1	6	2536	Table
odytraf_bail_bonds	0	1	7	1036	Table
odycivil_causes	1	1	7	7956	Table
cc_defendants	3	1	6	17812	Table
dscivil_related_persons	0	2	15	159040	Table
dscivil_complaints	3	1	14	47337	Table
odycivil_judgment_statuses	0	2	6	9092	Table
odytraf_charges	0	1	54	294761	Table
odycrim_aliases	0	3	6	17452	Table
cc	14	1	11	7815	Table
odytraf	12	1	18	294761	Table
odytraf_services	0	1	7	746	Table
odycrim_bail_bonds	0	1	7	8922	Table
odytraf_attorneys	0	3	15	302350	Table
odycrim_warrants	0	1	8	28390	Table
dsk8_trials	0	1	10	1886	Table
odycrim	14	1	10	93413	Table
odycrim_defendants	2	1	16	93608	Table
cases	11	0	16	905892	Table
dsk8_events	0	1	6	37956	Table
dsk8_bondsman	0	2	8	483	Table
odycivil	17	1	9	7409	Table
scrape_versions	1	1	4	921652	Table
cc_support_orders	0	1	28	138	Table
cc_court_schedule	0	1	12	3369	Table
odycivil_warrants	0	1	8	49	Table
dsk8_defendants	0	1	14	3054	Table
dscr_charges	0	1	38	58635	Table
odycivil_bail_bonds	0	1	7	1	Table