Metadata
Feedback
Login
Help
Production
Home
Data Models
Search
Metrics
Dictionaries
Standard Codes
Enterprise Model
Profiling
Mappings
Validation
Maps
Data Models
›
IRMAC Membership & Events
›
event_product
›
Details
Event Product Details
Business Name
Event Product
Table Name
event_product
Definition
A product that is offered with an Event. The Event Product includes the product code that must be used for internet payments.
Note
Entity Id
2375646
Container Name
IRMAC Database.erwin
Status
Active
Relationships
event
offers
Keys
PRIMARY
PK
Event Id
PRIMARY
PK
Product Code
XIF1Event Product
IF1
Event Id
Entity Attribute List
Go
Rows
1
5
10
15
20
25
50
100
1000
All
Actions
Link
Attribute Name
Datatype
Null Option
Definition
Event Id
integer
NotNull
A generated number to identify an event.
Product Code
varchar(20)
NotNull
The code of the product or service being offered. This must correspond to the code used in the InternetSecure Product List. For example, LUNCH for lunch guest ticket.
Product Description
varchar(80)
NotNull
The description of the product or service being offered.
Unit Price
decimal(11,2)
Null
The price of the product or service. This must be identical to the amount on the InternetSecure Product List.
1 - 4 of 4
Column Actions
Search
Key
PK - Primary Key
AKn - Alternate Keys
IFn - Foreign Keys
IEn - Index Entries