ここの情報は古いです。ご理解頂いた上でお取り扱いください。

source: OpenPNE3/trunk/config/schema.yml @ 9414

Last change on this file since 9414 was 9414, checked in by masabon, 13 years ago

#3131:added opActivateBehavior.class.php

File size: 3.1 KB
Line 
1propel:
2  member:
3    id: ~
4    name: { type: varchar(64), required: true }
5    is_active: { type: boolean, required: true }
6    created_at: ~
7    updated_at: ~
8    _behaviors:
9      activate: {}
10
11  member_relationship:
12    id: ~
13    member_id_to: { type: integer, required: true, foreignTable: member, foreignReference: id, OnDelete: cascade }
14    member_id_from: { type: integer, required: true, foreignTable: member, foreignReference: id, OnDelete: cascade }
15    is_friend: { type: boolean }
16    is_friend_pre: { type: boolean }
17    _uniques:
18      member_id_to_from: [ member_id_to, member_id_from ]
19      member_id_from_to: [ member_id_from, member_id_to ]
20
21  file:
22    id: ~
23    name: { type: varchar(64), index: unique, required: true }
24    original_filename: { type: longvarchar }
25    bin: { type: blob }
26    type: { type: varchar(64), required: true, index: true }
27    created_at: ~
28    updated_at: ~
29
30  profile:
31    id: ~
32    name: { type: varchar(64), index: unique, required: true }
33    is_required: { type: boolean, required: true }
34    is_unique: { type: boolean, required: true }
35    form_type: { type: varchar(32), required: true }
36    value_type: { type: varchar(32), required: true }
37    value_regexp: { type: longvarchar }
38    value_min: { type: integer }
39    value_max: { type: integer }
40    is_disp_regist: { type: boolean, required: true }
41    is_disp_config: { type: boolean, required: true }
42    is_disp_search: { type: boolean, required: true }
43    sort_order: { type: integer }
44
45  profile_i18n:
46    caption: { type: longvarchar, required: true }
47    info: { type: longvarchar }
48
49  profile_option:
50    id: ~
51    profile_id: ~
52    sort_order: { type: integer }
53
54  profile_option_i18n:
55    value: { type: longvarchar }
56
57  member_profile:
58    _attributes: { treeMode: NestedSet }
59    id: ~
60    lft_key: { type: integer, nestedSetLeftKey: true ,index: true }
61    rht_key: { type: integer, nestedSetRightKey: true ,index: true }
62    tree_key : { type: integer, treeScopeKey: true ,index: true }
63    member_id: ~
64    profile_id: ~
65    profile_option_id: ~
66    value: { type: longvarchar }
67
68  community:
69    id: ~
70    name: { type: varchar(64), index: unique, required: true }
71
72  community_member:
73    id: ~
74    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, OnDelete: cascade }
75    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, OnDelete: cascade }
76    position: { type: varchar(32), index: true }
77
78  admin_user:
79    id: ~
80    username: { type: varchar(64), index: unique, required: true }
81    password: { type: varchar(40), required: true }
82
83  sns_config:
84    id: ~
85    name: { type: varchar(64), index: unique, required: true }
86    value: { type: longvarchar }
87
88  member_config:
89    id: ~
90    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, OnDelete: cascade }
91    name: { type: varchar(64), required: true }
92    value: { type: longvarchar }
93
94  navi:
95    id: ~
96    type: { type: varchar(64), required: true, index: true }
97    uri: { type: longvarchar }
98
99  navi_i18n:
100    caption: { type: longvarchar }
Note: See TracBrowser for help on using the repository browser.