| 1 | /* |
| 2 | * Legal Notice |
| 3 | * |
| 4 | * This document and associated source code (the "Work") is a part of a |
| 5 | * benchmark specification maintained by the TPC. |
| 6 | * |
| 7 | * The TPC reserves all right, title, and interest to the Work as provided |
| 8 | * under U.S. and international laws, including without limitation all patent |
| 9 | * and trademark rights therein. |
| 10 | * |
| 11 | * No Warranty |
| 12 | * |
| 13 | * 1.1 TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, THE INFORMATION |
| 14 | * CONTAINED HEREIN IS PROVIDED "AS IS" AND WITH ALL FAULTS, AND THE |
| 15 | * AUTHORS AND DEVELOPERS OF THE WORK HEREBY DISCLAIM ALL OTHER |
| 16 | * WARRANTIES AND CONDITIONS, EITHER EXPRESS, IMPLIED OR STATUTORY, |
| 17 | * INCLUDING, BUT NOT LIMITED TO, ANY (IF ANY) IMPLIED WARRANTIES, |
| 18 | * DUTIES OR CONDITIONS OF MERCHANTABILITY, OF FITNESS FOR A PARTICULAR |
| 19 | * PURPOSE, OF ACCURACY OR COMPLETENESS OF RESPONSES, OF RESULTS, OF |
| 20 | * WORKMANLIKE EFFORT, OF LACK OF VIRUSES, AND OF LACK OF NEGLIGENCE. |
| 21 | * ALSO, THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT, |
| 22 | * QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION OR NON-INFRINGEMENT |
| 23 | * WITH REGARD TO THE WORK. |
| 24 | * 1.2 IN NO EVENT WILL ANY AUTHOR OR DEVELOPER OF THE WORK BE LIABLE TO |
| 25 | * ANY OTHER PARTY FOR ANY DAMAGES, INCLUDING BUT NOT LIMITED TO THE |
| 26 | * COST OF PROCURING SUBSTITUTE GOODS OR SERVICES, LOST PROFITS, LOSS |
| 27 | * OF USE, LOSS OF DATA, OR ANY INCIDENTAL, CONSEQUENTIAL, DIRECT, |
| 28 | * INDIRECT, OR SPECIAL DAMAGES WHETHER UNDER CONTRACT, TORT, WARRANTY, |
| 29 | * OR OTHERWISE, ARISING IN ANY WAY OUT OF THIS OR ANY OTHER AGREEMENT |
| 30 | * RELATING TO THE WORK, WHETHER OR NOT SUCH AUTHOR OR DEVELOPER HAD |
| 31 | * ADVANCE NOTICE OF THE POSSIBILITY OF SUCH DAMAGES. |
| 32 | * |
| 33 | * Contributors: |
| 34 | * Gradient Systems |
| 35 | */ |
| 36 | #ifndef W_CUSTOMER_H |
| 37 | #define W_CUSTOMER_H |
| 38 | |
| 39 | /* |
| 40 | * CUSTOMER table structure |
| 41 | */ |
| 42 | struct W_CUSTOMER_TBL { |
| 43 | ds_key_t c_customer_sk; |
| 44 | char c_customer_id[RS_BKEY + 1]; |
| 45 | ds_key_t c_current_cdemo_sk; |
| 46 | ds_key_t c_current_hdemo_sk; |
| 47 | ds_key_t c_current_addr_sk; |
| 48 | int c_first_shipto_date_id; |
| 49 | int c_first_sales_date_id; |
| 50 | char *c_salutation; |
| 51 | char *c_first_name; |
| 52 | char *c_last_name; |
| 53 | int c_preferred_cust_flag; |
| 54 | int c_birth_day; |
| 55 | int c_birth_month; |
| 56 | int c_birth_year; |
| 57 | char *c_birth_country; |
| 58 | char c_login[RS_C_LOGIN + 1]; |
| 59 | char c_email_address[RS_C_EMAIL + 1]; |
| 60 | int c_last_review_date; |
| 61 | }; |
| 62 | |
| 63 | int mk_w_customer(void *info_arr, ds_key_t kIndex); |
| 64 | |
| 65 | #endif |
| 66 | |