Skip to content

GitLab

Switch branch/tag
Find file Normal viewHistoryPermalink
schema.yml 1.96 KB
Newer Older
Игорь's avatar
init    
Игорь committed
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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122 
Session:
  columns:
    id:
      type: string(128)
      primary: true
    session_data:
      type: text
    session_time:
      type: integer
    user_id:
      type: integer
    token:
      type: string(255)
    device_id:
      type: string(255)
  relations:
    User:
      onDelete: CASCADE
      local: user_id
      foreign: id

Page:
  actAs:
    Timestampable: ~
  columns:
    title:
      type: string(255)
      notnull: true
    alias:
      type: string(255)
      unique: true
    body:
      type: string(50000)
    images:
      type: text
    is_activated:
      type: boolean
      notnull: true
      default: true

Cat:
  actAs:
    Timestampable: ~
  columns:
    title:
      type: string(1000)
      notnull: true
    min_weight:
      type: float(10,3)
    price:
      type: float(10,2)
    order_id:
      type: integer
      notnull: true
      default: 0

Export:
  actAs:
    Timestampable: ~
  columns:
    logic_type:
      type: enum
      values: ['bid', 'wait', 'bid_after_wait']
      notnull: true
    cat_id:
      type: integer
    weight:
      type: float(10,3)
    sum:
      type: float(10,2)
#    name:
#      type: string(50)
#    phone:
#      type: string(12)
    user_id:
      type: integer
  relations:
    Cat:
      onDelete: CASCADE
      local: cat_id
      foreign: id
    User:
      onDelete: CASCADE
      local: user_id
      foreign: id

MainMenu:
  columns:
    title:
      type: string(1000)
      notnull: true
    link:
      type: string(1000)
      notnull: true
    is_activated:
      type: boolean
      notnull: true
      default: true
    order_id:
      type: integer
      notnull: true
      default: 0

MailTemplate:
  columns:
    title:
      type: string(255)
      notnull: true
    event:
      type: string(255)
      notnull: true
      unique: true
    theme:
      type: string(1000)
      notnull: true
    copy:
      type: string(1000)
    params:
      type: string(10000)
    body:
      type: text
      notnull: true