tbls-gh-pages

user_profile

Description

Table Definition

```sql CREATE TABLE user_profile ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, first_name TEXT NOT NULL, last_name TEXT NOT NULL, birthdate DATE, address TEXT, phone_number TEXT, FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE ) ```

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	INTEGER		true
user_id	INTEGER		false		user
first_name	TEXT		false
last_name	TEXT		false
birthdate	DATE		true
address	TEXT		true
phone_number	TEXT		true

Constraints

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

Relations

---

Generated by tbls