Log with an auto identifier

Log with an auto identifier

The system stores technical events in the event_log table. Create the table with the following columns: - id — an automatically generated integer primary key; - kind — a required text field containing the event type; - created_at — the required event creation date and time without a time zone, defaulting to the current date and time. The database must generate the identifier automatically, so id does not need to be provided when adding an event normally. Use the automatic ID generation mechanism supported by your chosen SQL dialect.

Just CREATE/ALTER/DROP — no trailing SELECT needed.

PostgreSQLv16

Your query result will appear here

No starting schema

This task starts with no tables — you'll create them via CREATE TABLE.

Focus radio
Paused · SomaFM · Fluid