-
Notifications
You must be signed in to change notification settings - Fork 0
/
entity
44 lines (40 loc) · 773 Bytes
/
entity
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
39
40
41
42
43
44
Entity
- Users
* id : int
* name : varchar
* occupation : varchar
* password_hash : varchar
* avatar_file_name : varchar
* role : varchar
* token : varchar
* created_at : datetime
* updated_at : datetime
- Campaigns
* id : int
* user_id : int
* name : varchar
* short_description : varchar
* description : text
* goal_amount : int
* current_amount : int
* perks : text
* backer_count : int
* slug : varchar
* created_at : datetime
* updated_at : datetime
- Campaign Images
* id : int
* campaign_id : int
* file_name : varchar
* is_primary : boolean (tinyint)
* created_at : datetime
* updated_at : datetime
- Transactions
* id : int
* campaign_id : int
* user_id : int
* amount : int
* status : varchar
* code : varchar
* created_at : datetime
* updated_at : datetime