forked from erpeel-a/Farmer-Recommendation-System
-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema_database.txt
52 lines (44 loc) · 1.1 KB
/
schema_database.txt
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
45
46
47
48
49
50
51
52
user
-id int primary_key auto increment
-name varchar(255)
-email varchar(255)
-password varchar(255)
-created_at timestap
-updated_at timestap
wilayah
-id int primary_key auto increment
-nama_wilayah varchar(255)
-created_at timestap
-updated_at timestap
satuan
-id int primary_key auto increment
-nama_satuan
-created_at timestap
-updated_at timestap
kebutuhan per wilayah
-id int primary_key auto increment
-wilayah_id UnsignedBigInteger FK
-satuan_id UnsignedBigInteger FK
-nama_kebutuhan varchar(255)
-harga kebutuhan varchar(255)
-keterangan text
-created_at timestap
-updated_at timestap
rekomendasi
-id int primary_key auto increment
-kebutuhan_id UnsignedBigInteger FK
-jumlah
-harga total
-created_at timestap
-updated_at timestap
rekomendasi musim tanam
-id int primary_key auto increment
-wilayah_id UnsignedBigInteger FK
-rekomendasi_id UnsignedBigInteger FK
-nama_petani varchar(255)
-nama_musim varchar(255)
-luas_tanah varhar(255)
-tanggal_tanam date
-created_at timestap
-updated_at timestap
NB: nek pengen ditambahi softdelete monggo