17 lines
278 B
Plaintext
17 lines
278 B
Plaintext
Table users {
|
|
id integer
|
|
username varchar
|
|
role varchar
|
|
created_at timestamp
|
|
}
|
|
|
|
Table posts {
|
|
id integer [primary key]
|
|
title varchar
|
|
body text [note: 'Content of the post']
|
|
user_id integer
|
|
created_at timestamp
|
|
}
|
|
|
|
Ref: posts.user_id > users.id
|