tbls-gh-pages

user_status

Description

Table Definition

```sql CREATE TABLE user_status ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, status_id INTEGER NOT NULL, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE, FOREIGN KEY (status_id) REFERENCES status_types (id) ) ```

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	INTEGER		true
user_id	INTEGER		false		user
status_id	INTEGER		false		status_types
updated_at	DATETIME	CURRENT_TIMESTAMP	true

Constraints

Name	Type	Definition
id	PRIMARY KEY	PRIMARY KEY (id)
- (Foreign key ID: 0)	FOREIGN KEY	FOREIGN KEY (status_id) REFERENCES status_types (id) ON UPDATE NO ACTION ON DELETE NO ACTION MATCH NONE
- (Foreign key ID: 1)	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES user (id) ON UPDATE NO ACTION ON DELETE CASCADE MATCH NONE

Relations

---

Generated by tbls