I am trying to get all these fields dropped on a report, and hours later I
still
don't have anything useful. I am all for helping improve things, but I am
running out of time. I need to go to the store and eat. when I come back I
am
going to just do it manually, unless someone has fixed the current problems:
1 big stack of fields
2 no sample data
I can take care of arranging things, im just looking for the automated stuff to
produce something better than it currently does. Ideally just post the rfxml
made from the data below.
Here is the data I am working with - pfi is teh de-normalized version of all 3,
guessing that's the only thing I really need.
Carl K
CREATE TABLE t2_person(
id INTEGER PRIMARY KEY AUTOINCREMENT,
name CHAR(32),
first_name CHAR(32),
last_name CHAR(32),
badge_line1 CHAR(32),
badge_line2 CHAR(32),
email CHAR(128),
password CHAR(32),
address1 CHAR(128),
address2 CHAR(128),
city CHAR(32),
state CHAR(32),
country CHAR(32),
zip_code CHAR(32),
phone_number CHAR(32),
personal_home_page CHAR(128),
company_name CHAR(32),
company_home_page CHAR(128),
hotel CHAR(32),
include_in_delegate_listing CHAR(1),
food_preference CHAR(32),
t_shirt_size CHAR(32),
sprints CHAR(32),
attendee_type CHAR(32),
donation_to_PSF DOUBLE,
tutorials TEXT,
discount_coupon CHAR(64),
captcha CHAR(32),
amount_billed DOUBLE,
amount_added DOUBLE,
amount_subtracted DOUBLE,
amount_paid DOUBLE,
amount_due DOUBLE,
speaker CHAR(1),
session_chair CHAR(1),
manager CHAR(1),
reviewer CHAR(1),
latitude DOUBLE,
longitude DOUBLE,
checkout_status CHAR(32),
pay_token CHAR(32),
registration_key CHAR(64),
created_by_ip CHAR(32),
created_on TIMESTAMP
);
CREATE TABLE expense_form(
id INTEGER PRIMARY KEY AUTOINCREMENT,
person REFERENCES t2_person(id) ON DELETE CASCADE,
event CHAR(20),
created_on TIMESTAMP
);
CREATE TABLE expense_item(
id INTEGER PRIMARY KEY AUTOINCREMENT,
exp_form REFERENCES expense_form(id) ON DELETE CASCADE,
seq INTEGER,
receipt_no INTEGER,
receipt_item INTEGER,
acct_code CHAR(20),
description TEXT,
serial_no CHAR(30),
location TEXT,
amount DOUBLE
);
CREATE TABLE pfi(
id INTEGER PRIMARY KEY AUTOINCREMENT,
person_id INTEGER ,
first_name CHAR(32),
last_name CHAR(32),
email CHAR(128),
address1 CHAR(128),
address2 CHAR(128),
city CHAR(32),
state CHAR(32),
country CHAR(32),
zip_code CHAR(32),
phone_number CHAR(32),
company_name CHAR(32),
expense_form_id INTEGER,
event CHAR(20),
expense_item_id INTEGER,
seq INTEGER,
receipt_no INTEGER,
receipt_item INTEGER,
acct_code CHAR(20),
description TEXT,
serial_no CHAR(30),
location TEXT,
amount DOUBLE
);
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
