YAML --- propel geo-related entities country id title type varchar 50

  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
%YAML 1.1
---
propel:
############## geo-related entities ###############
country:
id:
title:
type: varchar(50)
required: true
short:
type: varchar(3)
required: true
location:
id:
country_id:
name:
type: varchar(100)
required: true
################## learning-related entities ################
university:
_attributes:
idMethod: native
id:
short_title: varchar(15)
title: varchar(100)
location_id:
discipline:
id:
name: varchar(50)
homework:
id:
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true }
title:
type: varchar(100)
required: true
excerpt: longvarchar
file_collection_id:
author_id:
discipline_id:
price:
type: integer
required: true
rating:
type: float
faculty_to_tutor: #reflects that any teacher could work for many universities
_attributes:
idMethod: native
id:
tutor_id:
university_id:
#################### people-related entities ##############
author:
_attributes:
idMethod: native
id:
name:
type: varchar
size: 30
tutor:
_attributes:
idMethod: native
id:
name:
type: varchar(30)
required: true
faculty_to_tutor_id:
sf_guard_user_profile:
_attributes: { phpName: sfGuardUserProfile }
id:
user_id: { type: integer, foreignTable: sf_guard_user, foreignReference: id, required: true, onDelete: cascade }
first_name:
type: varchar(20)
required: true
last_name:
type: varchar(20)
required: true
birthday:
type: date
required: true
email:
type: varchar(50)
required: true
location_id:
phone: varchar(20)
icq: varchar(11)
############# internal data structure-related entities #############
file:
id:
name:
type: varchar(255)
required: true
path:
type: longvarchar
required: true
description:
type: longvarchar
required: true
file_category_id:
file_category:
id:
name:
type: varchar(255)
required: true
file_collection:
id:
file_id: