Report for Comic-con_parking made in Luna Modeler

PARKING_LEVEL_parking_zone_id_fkey1

PARKING_LEVEL_parking_zone_id_fkey

Name

PARKING_LEVEL

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

parking_zone_id

uuid

level_code

varchar

Keys

PARKING_LEVEL_pkey

Column in PARKING_LEVEL_pkey

id

Relations

Name

Parent

Child

PARKING_SPOT_parking_level_id_fkey

PARKING_LEVEL_parking_zone_id_fkey1

VEHICLE_SPOT_CATEGORY_spot_category_id_fkey

Name

SPOT_CATEGORY

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

first_name

varchar

last_name

varchar

description

text

Keys

SPOT_CATEGORY_pkey

Column in SPOT_CATEGORY_pkey

id

Relations

Name

Parent

Child

PARKING_SPOT_spot_category_id_fkey

VEHICLE_SPOT_CATEGORY_vehicle_category_id_fkey

Name

VECHICLE_CATEGORY

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

name

integer

description

text

Keys

VECHICLE_CATEGORY_pkey

Column in VECHICLE_CATEGORY_pkey

id

Relations

Name

Parent

Child

VECHICLE_CATEGORY

PARKING_SPOT_parking_level_id_fkey

Name

PARKING_SPOT

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

parking_level_id

uuid

spot_category_id

uuid

spot_number

varchar

is_reserved

bool

is_ev_charging

bool

is_available

bool

Keys

PARKING_SPOT_pkey

Column in PARKING_SPOT_pkey

id

Relations

Name

Parent

Child

PARKING_SPOT_spot_category_id_fkey

PARKING_SESSION_parking_spot_id_fkey

VEHICLE_SPOT_CATEGORY_vehicle_category_id_fkey

Name

VEHICLE_SPOT_CATEGORY

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

vehicle_category_id

uuid

spot_category_id

uuid

Keys

VEHICLE_SPOT_CATEGORY_pkey

Column in VEHICLE_SPOT_CATEGORY_pkey

id

Relations

Name

Parent

Child

VECHICLE_CATEGORY

VEHICLE_SPOT_CATEGORY_spot_category_id_fkey

VEHICLE_vehicle_category_id_fkey

VEHICLE_vehicle_category_id_fkey

Name

VEHICLE

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

vehicle_category_id

uuid

license_plate

varchar

maker

varchar

model

text

color

varchar

owner_name

varchar

owner_contact

varchar

created_at

timestamp

Keys

VEHICLE_pkey

Column in VEHICLE_pkey

id

Relations

Name

Parent

Child

PARKING_SESSION_vehicle_id_fkey

PARKING_SESSION_access_category_id_fkey

Name

ACCESS_CATEGORY

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

name

varchar

description

text

Keys

ACCESS_CATEGORY_pkey

Column in ACCESS_CATEGORY_pkey

id

Relations

Name

Parent

Child

ACCESS_CATEGORY

PARKING_SESSION_access_category_id_fkey

Name

PARKING_SESSION

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

vehicle_id

uuid

parking_spot_id

uuid

access_category_id

uuid

entry_time

timestamp

exit_time

timestamp

status

Keys

PARKING_SESSION_pkey

Column in PARKING_SESSION_pkey

id

Relations

Name

Parent

Child

ACCESS_CATEGORY

PARKING_SESSION_vehicle_id_fkey

PARKING_SESSION_parking_spot_id_fkey

PARKING_TICKET_parking_session_id_fkey

PARKING_TICKET_parking_session_id_fkey

Lines

status-status

Name

PARKING_TICKET

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

parking_session_id

uuid

ticket_number

varchar

issued_at

timestamp

base_rate_per_hour

float8

total_amount

float8

Keys

PARKING_TICKET_pkey

Column in PARKING_TICKET_pkey

id

Relations

Name

Parent

Child

PAYMENT_parking_ticket_id_fkey

PAYMENT_parking_ticket_id_fkey

PAYMENT

Name

PAYMENT

Columns

Name

Data type

Param

Key

Not Null

id

uuid

Yes

parking_ticket_id

uuid

amount_paid

payment_method

payment_status

paid_at

timestamp

transaction_ref

varchar

Keys

PAYMENT_pkey

Column in PAYMENT_pkey

id

Relations

Name

Parent

Child

payment_status-payment_status

PAYMENT

Lines

payment_method-payment_method

relationships

Name

PARKING_LEVEL_parking_zone_id_fkey

Name

Source

Target

PARKING_LEVEL_parking_zone_id_fkey

VEHICLE_SPOT_CATEGORY_vehicle_category_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in PARKING_ZONE

Column in PARKING_LEVEL

PARKING_ZONE_pkey

id

parking_zone_id

Name

VEHICLE_SPOT_CATEGORY_vehicle_category_id_fkey

Name

Source

Target

VECHICLE_CATEGORY

VEHICLE_SPOT_CATEGORY_spot_category_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in VECHICLE_CATEGORY

Column in VEHICLE_SPOT_CATEGORY

VECHICLE_CATEGORY_pkey

id

vehicle_category_id

Name

VEHICLE_SPOT_CATEGORY_spot_category_id_fkey

Name

Source

Target

PARKING_SPOT_parking_level_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in SPOT_CATEGORY

Column in VEHICLE_SPOT_CATEGORY

SPOT_CATEGORY_pkey

id

spot_category_id

Name

PARKING_SPOT_parking_level_id_fkey

Name

Source

Target

PARKING_SPOT_spot_category_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in PARKING_LEVEL

Column in PARKING_SPOT

PARKING_LEVEL_pkey

id

parking_level_id

Name

PARKING_SPOT_spot_category_id_fkey

Name

Source

Target

PARKING_LEVEL_parking_zone_id_fkey1

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in SPOT_CATEGORY

Column in PARKING_SPOT

SPOT_CATEGORY_pkey

id

spot_category_id

Name

PARKING_LEVEL_parking_zone_id_fkey1

Name

Source

Target

VEHICLE_vehicle_category_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in PARKING_ZONE

Column in PARKING_LEVEL

PARKING_ZONE_pkey

id

parking_zone_id

Name

VEHICLE_vehicle_category_id_fkey

Name

Source

Target

PARKING_SESSION_access_category_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in VEHICLE_SPOT_CATEGORY

Column in VEHICLE

VEHICLE_SPOT_CATEGORY_pkey

id

vehicle_category_id

Name

PARKING_SESSION_access_category_id_fkey

Name

Source

Target

ACCESS_CATEGORY

PARKING_SESSION_vehicle_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in ACCESS_CATEGORY

Column in PARKING_SESSION

ACCESS_CATEGORY_pkey

id

access_category_id

Name

PARKING_SESSION_vehicle_id_fkey

Name

Source

Target

PARKING_SESSION_parking_spot_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in VEHICLE

Column in PARKING_SESSION

VEHICLE_pkey

id

vehicle_id

Name

PARKING_SESSION_parking_spot_id_fkey

Name

Source

Target

PARKING_TICKET_parking_session_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in PARKING_SPOT

Column in PARKING_SESSION

PARKING_SPOT_pkey

id

parking_spot_id

Name

PARKING_TICKET_parking_session_id_fkey

Name

Source

Target

PAYMENT_parking_ticket_id_fkey

Cardinality type:

One to

many

Ordinality:

Mandatory

Key and columns

Key name

Column in PARKING_SESSION

Column in PARKING_TICKET

PARKING_SESSION_pkey

id

parking_session_id

Name

PAYMENT_parking_ticket_id_fkey

Name

Source

Target