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.
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inNo starting schema
This task starts with no tables — you'll create them via CREATE TABLE.
Focus radio
Paused · SomaFM · Fluid