编辑 schema.yml - 文件管理器

✏️ 编辑：schema.yml

路径：/virtual/bigbrother/sns/config/schema.yml

大小：6.84 KB · 修改：2010-08-10 13:59:42 · 权限：0644 · 可写

propel:
  member:
    id: ~
    name: { type: varchar(64), required: true, defaultValue: "" }
    is_active: { type: boolean, required: true, defaultValue: 0 }
    invite_member_id: { type: integer, required: false, foreignTable: member, foreignReference: id, onDelete: setnull }
    created_at: ~
    updated_at: ~
    _behaviors:
      activate: {}

member_relationship:
    id: ~
    member_id_to: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    member_id_from: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    is_friend: { type: boolean }
    is_friend_pre: { type: boolean }
    is_access_block: { type: boolean }
    _uniques:
      member_id_to_from: [ member_id_to, member_id_from ]
      member_id_from_to: [ member_id_from, member_id_to ]

member_image:
    id: ~
    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    file_id: { type: integer, required: true, foreignTable: file, foreignReference: id, onDelete: cascade }
    is_primary: { type: boolean }

file:
    id: ~
    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    original_filename: { type: longvarchar }
    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
    created_at: ~
    updated_at: ~

file_bin:
    file_id: { type: integer, required: true, primaryKey: true, foreignTable: file, foreignReference: id, onDelete: cascade }
    bin: { type: blob }

profile:
    id: ~
    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    is_required: { type: boolean, required: true, defaultValue: 0 }
    is_unique: { type: boolean, required: true, defaultValue: 0 }
    is_edit_public_flag: { type: boolean, required: true, defaultValue: 0 }
    default_public_flag: { type: tinyint, required: true, defaultValue: 1 }
    form_type: { type: varchar(32), required: true, defaultValue: "" }
    value_type: { type: varchar(32), required: true, defaultValue: "" }
    value_regexp: { type: longvarchar }
    value_min: { type: varchar(32) }
    value_max: { type: varchar(32) }
    is_disp_regist: { type: boolean, required: true, defaultValue: 0 }
    is_disp_config: { type: boolean, required: true, defaultValue: 0 }
    is_disp_search: { type: boolean, required: true, defaultValue: 0 }
    sort_order: { type: integer }

profile_i18n:
    caption: { type: longvarchar, required: true }
    info: { type: longvarchar }

profile_option:
    id: ~
    profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade }
    sort_order: { type: integer }

profile_option_i18n:
    value: { type: longvarchar }

member_profile:
    _attributes: { treeMode: NestedSet }
    id: ~
    lft_key: { type: integer, nestedSetLeftKey: true, index: true, defaultValue: 0 }
    rht_key: { type: integer, nestedSetRightKey: true, index: true, defaultValue: 0 }
    tree_key : { type: integer, treeScopeKey: true, index: true }
    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    profile_id: { type: integer, required: true, foreignTable: profile, foreignReference: id, onDelete: cascade }
    profile_option_id: { type: integer, required: false, foreignTable: profile_option, foreignReference: id, onDelete: cascade }
    value: { type: longvarchar }
    public_flag: { type: tinyint, required: false }

community:
    id: ~
    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    file_id: { type: integer, required: false, foreignTable: file, foreignReference: id, onDelete: setnull }
    community_category_id: { type: integer, required: false, foreignTable: community_category, foreignReference: id, onDelete: setnull }
    created_at: ~
    updated_at: ~

community_member:
    id: ~
    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    position: { type: varchar(32), index: true, defaultValue: "" }

admin_user:
    id: ~
    username: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    password: { type: varchar(40), required: true, defaultValue: "" }

sns_config:
    id: ~
    name: { type: varchar(64), index: unique, required: true, defaultValue: "" }
    value: { type: longvarchar }

member_config:
    id: ~
    member_id: { type: integer, required: true, foreignTable: member, foreignReference: id, onDelete: cascade }
    name: { type: varchar(64), required: true, defaultValue: "" }
    value: { type: longvarchar }

community_config:
    id: ~
    community_id: { type: integer, required: true, foreignTable: community, foreignReference: id, onDelete: cascade }
    name: { type: varchar(64), required: true, defaultValue: "" }
    value: { type: longvarchar }

community_category:
    _attributes: { treeMode: NestedSet }
    id: ~
    lft_key: { type: integer, nestedSetLeftKey: true, index: true, defaultValue: 0 }
    rht_key: { type: integer, nestedSetRightKey: true, index: true, defaultValue: 0 }
    tree_key : { type: integer, treeScopeKey: true, index: true }
    name: { type: varchar(64), required: true, defaultValue: "" }
    sort_order: { type: integer }
    is_allow_member_community: { type: boolean, required: true, defaultValue: 1 }

gadget:
    id: ~
    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
    name: { type: varchar(64), required: true, defaultValue: "" }
    sort_order: { type: integer }

gadget_config:
    id: ~
    gadget_id: { type: integer, foreignTable: gadget, foreignReference: id, onDelete: cascade }
    name: { type: varchar(64), required: true, defaultValue: "" }
    value: { type: longvarchar }

navigation:
    id: ~
    type: { type: varchar(64), required: true, index: true, defaultValue: "" }
    uri: { type: longvarchar, required: true }
    sort_order: { type: integer }

navigation_i18n:
    caption: { type: longvarchar, required: true }

blacklist:
    id: ~
    uid: { type: varchar(32), index: unique, required: true, defaultValue: "" }
    memo: { type: longvarchar }

banner:
    id: ~
    name: { type: varchar(32), index: unique, required: true }
    html: { type: longvarchar }
    is_use_html: { type: boolean }

banner_i18n:
    caption: { type: longvarchar, required: true }

banner_image:
    id: ~
    file_id: { type: integer, required: true, foreignTable: file, foreignReference: id, onDelete: cascade }
    url: { type: longvarchar }
    name: { type: varchar(64) }

banner_use_image:
    id: ~
    banner_id: { type: integer, required: true, foreignTable: banner, foreignReference: id }
    banner_image_id: { type: integer, required: true, foreignTable: banner_image, foreignReference: id }

ページが見つかりませんでした – Lumiere Shop