detect_relations: true
options:
collate: utf8_general_ci
charset: utf8
type: InnoDB

Visit:
actAs:
Timestampable: ~
columns:
id:
type: integer(4)
primary: true
notnull: true
autoincrement: true
patient_id:
type: integer(8)
notnull: true
dentist_id:
type: integer(8)
notnull: true
service_id:
type: integer(4)
notnull: true
visit_status_id:
type: integer(4)
notnull: true
time_id:
type: integer(4)
notnull: true
date:
type: date
notnull: true
confirmed:
type: integer(1)
notnull: true
default: 0
description:
type: string(255)
relations:
sfGuardUser:
local: patient_id
foreign: id
foreignAlias: visits
onDelete: cascade
onUpdate: cascade
foreignType: many
owningSide: true
sfGuardUserDentist:
class: sfGuardUser
local: dentist_id
foreign: id
foreignAlias: visits
onDelete: cascade
onUpdate: cascade
foreignType: many
owningSide: true
Service:
local: service_id
foreign: id
foreignAlias: visits
onDelete: cascade
onUpdate: cascade
foreignType: many
owningSide: true
VisitStatus:
local: visit_status_id
foreign: id
foreignAlias: visits
onDelete: cascade
onUpdate: cascade
foreignType: many
owningSide: true
Time:
local: time_id
foreign: id
foreignAlias: visits
onDelete: cascade
onUpdate: cascade
foreignType: many
owningSide: true
indexes:
fk_visit_sf_guard_user:
fields: [patient_id]
fk_visit_sf_guard_user1:
fields: [dentist_id]
fk_visit_service1:
fields: [service_id]
fk_visit_visit_status1:
fields: [visit_status_id]
fk_visit_time1:
fields: [time_id]

VisitStatus:
tableName: visit_status
columns:
id:
type: integer(4)
primary: true
notnull: true
autoincrement: true
name:
type: string(255)

Service:
columns:
id:
type: integer(4)
primary: true
notnull: true
autoincrement: true
name:
type: string(255)
price:
type: double(18,2)

Time:
columns:
id:
type: integer(4)
primary: true
notnull: true
autoincrement: true
name:
type: string(255)

UserTime:
tableName: user_time
columns:
sf_guard_user_id:
type: integer(8)
primary: true
notnull: true
time_id:
type: integer(4)
primary: true
notnull: true
date:
type: date
primary: true
notnull: true
relations:
sfGuardUser:
local: sf_guard_user_id
foreign: id
foreignAlias: userTimes
foreignType: many
owningSide: true
Time:
local: time_id
foreign: id
foreignAlias: userTimes
foreignType: many
owningSide: true
indexes:
fk_sf_guard_user_has_time_time1:
fields: [time_id]
fk_sf_guard_user_has_time_sf_guard_user1:
fields: [sf_guard_user_id]

sfGuardUser:
admin:
first_name: John
last_name: Doe
email_address: john.doe@gmail.com
username: admin
password: admin
is_super_admin: true
Groups: [admin]
<?php for ($i = 0; $i < 7; $i++): ?>
patient<?php echo $i ?>:
first_name: Patient<?php echo $i . " \n" ?>
last_name: Wayne
email_address: agent<?php echo $i ?>@gabdc
username: agent<?php echo $i . " \n" ?>
password: admin
is_super_admin: false
Groups: [patient]
<?php endfor ?>
sd1:
first_name: Stanisław
last_name: Wiercidziura
email_address: mailnaspam7@gmail.com
username: stasiek
password: admin
is_super_admin: false
Groups: [dentist]
sd2:
first_name: Mirosław
last_name: Boliząb
email_address: mailnaspam8@gmail.com
username: mirek
password: admin
is_super_admin: false
Groups: [dentist]

sfGuardGroup:
admin:
name: admin
description: Administratorzy
Permissions: [admin]
dentist:
name: dentist
description: Stomatolodzy
Permissions: [dentist]
patient:
name: patient
description: Pacjenci
Permissions: [patient]

sfGuardPermission:
admin:
name: admin
description: Administrator permission
dentist:
name: dentist
description: Dentist permission
patient:
name: patient
description: Patient permission

Service:
borowanie:
name: borowanie
price: 100
wybielanie:
name: wybielanie
price: 350
leczenie:
name: leczenie
price: 80
diagnostyka:
name: diagnostyka
price: 50

Time:
1:
name: 8 - 9
2:
name: 9 - 10
3:
name: 10 - 11
4:
name: 11 - 12
5:
name: 12 - 13
6:
name: 13 - 14
7:
name: 14 - 15
8:
name: 15 - 16

VisitStatus:
odwolana:
name: Odwołana
oczekaująca:
name: Oczekująca
zakończona:
name: Zakończona
nie_odbyla_sie:
name: Nie odbyła się

Visit:
<?php for ($i=0;$i<5;$i++): ?>
visit<?php echo $i?>:
sfGuardUser: patient<?php echo $i . " \n" ?>
sfGuardUserDentist: sd<?php echo rand(1,2) . " \n" ?>
service_id: <?php echo rand(1,4) . " \n" ?>
visit_status_id: <?php echo rand(1,4) . " \n" ?>
time_id: <?php echo rand(1,8) . " \n" ?>
confirmed: <?php echo rand(0,1) . "\n" ?>
description: Lorem ipsum terefere
date: <?php echo time() + 86400 * $i . " \n" ?>
<?php endfor ?>