-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.js
38 lines (32 loc) · 1.33 KB
/
schema.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
var Schema = {
users: {
id: {type: 'increments', nullable: false, primary: true},
email: {type: 'string', maxlength: 254, nullable: false, unique: true},
name: {type: 'string', maxlength: 150, nullable: false}
},
categories: {
id: {type: 'increments', nullable: false, primary: true},
name: {type: 'string', maxlength: 150, nullable: false}
},
posts: {
id: {type: 'increments', nullable: false, primary: true},
user_id: {type: 'integer', nullable: false, unsigned: true},
category_id: {type: 'integer', nullable: false, unsigned: true},
title: {type: 'string', maxlength: 150, nullable: false},
slug: {type: 'string', maxlength: 150, nullable: false, unique: true},
html: {type: 'text', maxlength: 16777215, fieldtype: 'medium', nullable: false},
created_at: {type: 'dateTime', nullable: false},
updated_at: {type: 'dateTime', nullable: true}
},
tags: {
id: {type: 'increments', nullable: false, primary: true},
slug: {type: 'string', maxlength: 150, nullable: false, unique: true},
name: {type: 'string', maxlength: 150, nullable: false}
},
posts_tags: {
id: {type: 'increments', nullable: false, primary: true},
post_id: {type: 'integer', nullable: false, unsigned: true},
tag_id: {type: 'integer', nullable: false, unsigned: true}
}
};
module.exports = Schema;