Sql table to store status

CREATE TABLE status
(
  id integer PRIMARY KEY,
  name TEXT NOT NULL,
  next_status Integer references status
);

insert into status(id, name, next_status)
values 
(1,'init', 2),
(2,'waiting ror price approve', 3),
(3,'sent', 4),
(4,'accepted', 5),
(5,'finished', null);

Source: stackoverflow.com

Similar codes

0 vote286 views1 answer
Exit psql
SQL
0 vote224 views1 answer
Import csv to mysql
SQL
0 vote275 views2 answers
Sqlite unique
SQL
0 vote290 views1 answer
Sql gather statistics to increase performance
SQL
18 votes232 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote263 views1 answer
Insert thai language sql server
SQL
0 vote273 views1 answer
How to drop a trigger in postgresql
SQL
14 votes274 views3 answers
Sql trim from string
SQL
0 vote278 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote267 views1 answer
Postgresql where clause not working
SQL