drop table if exists BUDGET_LOG.LADEVORGAENGE cascade;

create table if not exists
    BUDGET_LOG.LADEVORGAENGE (ID               uuid
                                 default gen_random_uuid()
                                 constraint PK⠒LV⠒ID primary key, 
                              LADEVORGANG_PT   timestamp
                                 default current_timestamp
                                 not null
                                 constraint UK⠒LV⠒LADEVORGANG_PT unique);


comment on table BUDGET_LOG.LADEVORGAENGE is
    'Logtabelle, welche die Zeitpunkte von Ladevorgängen enthält
$Id: ladevorgaenge.pg_sql 2639 2023-10-26 16:32:50Z thiemo $';
comment on column BUDGET_LOG.LADEVORGAENGE.ID is
    'Primärschlüssel';
comment on column BUDGET_LOG.LADEVORGAENGE.LADEVORGANG_PT is
    'Zeitpunkt, wann der Ladevorgang stattgefunden hat';

commit;