Skip to content
Dev.to1 min read

Consistency

Hi! To explore how the database enforces rules that maintain valid data states, particularly ensuring that account balances never become negative. first create a table account, CREATE TABLE accounts (id SERIAL PRIMARY KEY,name TEXT NOT NULL,balance INT NOT NULL CHECK (balance >= 0),last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP); the table contains atributes id as primary key,name,balance hee check for condition as if balance >=0,last_updated here set default value as current timestamp. Next,i
Read original on dev.to
0
0

Comment

Sign in to join the discussion.

Loading comments…

Related

Get the 10 best reads every Sunday

Curated by AI, voted by readers. Free forever.

Liked this? Start your own feed.

0
0