This repository has been archived by the owner on Apr 10, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Other Tables
jules2689 edited this page Nov 12, 2014
·
3 revisions
| column | type |
|---|---|
| id | PK (int) |
| subject | varchar(255) |
| description | TEXT |
| column | type |
|---|---|
| id | PK (int) |
| start_time | datetime |
| end_time | datetime |
| event_id | FK |
| column | type |
|---|---|
| id | PK (int) |
| image | image* |
| event_id | FK |
Image will be started on Amazon, this is actually a link
| column | type |
|---|---|
| id | PK (int) |
| address1 | varchar(255) |
| address2 | varchar(255) |
| City | varchar(255) |
| State | varchar(255) |
| Country | varchar(255) |
| PostalCode | varchar(255) |
| latitude | varchar(255) |
| longitude | varchar(255) |
Latitude and Longitude are fetched in the background upon creation of an Address entry. This will allow easy matching via javascript libraries
The tracking of all transactions through the system. Links to stripe id
| column | type |
|---|---|
| id | PK (int) |
| event_id | FK |
| customer_id | FK |
| event_id | FK |
| price | Decimal(10,2) |
| tax | Decimal(10,2) |
| stripe_id | int |