Defining an XML Schema - Best practices?

[MattWoberts]

Hi,

I want to define a schema for an "event" - this event has an associated status (open, closed etc..). In my database, I have a table for teh event and a table for the status, so the event holds a status_id (foreign key).

My question is, how do I best define a schema for this, does it have an entity called statusID or statusName (or both?)... It gets confusing because I want to use the schema to define both events that can be imported into the system (in which case I need StatusID) and events that can be exported to reports (in which case I need statusName).

Any advice weclome!!