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 vote418 views1 answer
Sql server remove primary key without dropping table
SQL
1 vote367 views1 answer
Mysql select all and rename one
SQL
0 vote355 views1 answer
Check if database exists sql
SQL
9 votes396 views1 answer
Alter table column change data type to text mysql
SQL
0 vote359 views2 answers
How to know the character set of an oracle databes
SQL
0 vote348 views1 answer
How to avoid duplicate records in sqlite
SQL
-1 vote327 views1 answer
How to format tables in sqlplus
SQL
4 votes388 views1 answer
How to drop a database in sql server when it is in use
SQL
5 votes374 views1 answer
Mysql created at yesterdau
SQL
0 vote400 views2 answers
Mysql insert into multiple tables
SQL