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

1 vote156 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
17 votes153 views3 answers
How to change a collumn name in sql
SQL
2 votes184 views1 answer
Python sql
SQL
12 votes153 views2 answers
Update column data type postgres
SQL
0 vote151 views1 answer
Insufficient memory to excute the sql query
SQL
10 votes164 views4 answers
How to alter table name in mysql
SQL
0 vote149 views1 answer
Mysql coonect sample code
SQL
0 vote152 views2 answers
Enter into postgresql database,create user and grant Access
SQL
38 votes158 views4 answers
Count sql
SQL
1 vote150 views1 answer
Mysql show table character set
SQL