ERW

The Manual

Sebastiano Vigna


Table of Contents
Preface
A Simple Example
Overall System Design
Entity-Relationship Schemata
Cardinality Constraints
Weak Entities
Subtyping
Reification
Concurrency
ERL: an Entity-Relationship Language
A Quick Tour
Types and Identifiers
The enum type
The fset type
Elements
erl -- A whole entity-relationship schema
enumval -- A value/label pair of a static enumerative type
enum -- A declaration of a static enumerative type
fset -- A declaration of a fileset type
attr -- An attribute of an entity or relationship type
isa -- A reference to a supertype.
ent -- An entity of an entity-relationship schema
leg -- A leg of a relationship type in an entity-relationship schema
rel -- A relationship type in an entity-relationship schema
The User Interface
Stateless Editing
Simulating Remote Procedure Calls
State Discrepancies
Caching
Customisation
User Interface Customisation
ERL Types vs. ERW Types
Attribute Specifiers
Custom Files
The Type Array
Customising Labels
Ordering Elements
Customising Filters
Hooks
The Lock Hook
The Pre-update Hook
The Post-update Hook
The Deletion Hooks
The Post-Authorisation Hook
The Selection-load Hook
The Button Hook
The Button Inhibition Hook
The Form-Loading Hook
Custom Forms
Form Resolution
ERF: an Entity-Relationship Form Language
Authentication and Authorisation
Custom Authentication
The Authorisation System
Changing Owner
The Selection Level Tuning
Restrictions on Element-Based Authorisation
Transaction Support
Installation and Configuration
The Run-Time Environment
The ERW-conf.php Initialisation File
Configuring PHP
Configuring HTMLArea
Configuring FCKeditor
Configuring JSCalendar
ERtool
Options
Checks
Error Messages
The DOT graphical back-end
The ERW Graphical Notation
Entity Types
Relationship Types
Standards and Browser Requirements
Useful Functions
Database Functions
JavaScript Functions
Localisation
Language Configuration Variables
Other Localisation Variables
UTF-8 Support
Script Reference
ERW/checkERW.php
ERW/checkdb.php
ERW.php
list.php
form.php
default.php
chown.php
setprefs.php
Troubleshooting
ERtool problems
PHP problems
SQL problems
Configuration and Customisation Problems
When Nothing Seems to Work
Reporting Bugs
GNU Free Documentation License
Preamble
Applicability and Definitions
Verbatim Copying
Copying in Quantity
Modifications
Combining Documents
Collections of Documents
Aggregation With Independent Works
Translation
Termination
Future Revisions of This Licence