Re: Design Help Needed
HI Sudheer, THIS DESIGN IS BASED ON MY MANY-TO-ONE DIRECTION PATTERN OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD) AND DIRECT JDBC FOR MY QUERIES(R). YOU MAY VARY. HERE, HOPE THIS WILL GIVE YOU AN IDEA. LEGEND: X-TABLE, L-LONG, S-STRING/CHAR(?), T-DATETIME _ID-PRIMARY_KEY, REF-FOREIGN_KEY X:CONTACTS_AND_ADDRESSES L:CONTACT_AND_ADDRESS_ID S:WEBSITE S:EMAIL S:MESSAGING S:TELEPHONE S:MOBILE S:LAND_ADDRESS T:CREATED/MODIFIED X:INDIVIDUALS L:INDIVIDUAL_ID S:USERNAME S:PASSWORD S:DISPLAY_NAME S:PICTURE_URI S:SECURITY_QUESTION S:ANSWER T:CREATED/MODIFIED X:INDIVIDUALS_CONTACTS_AND_ADDRESSES L:INDIVIDUAL_CONTACT_AND_ADDRESS_ID L:REF_INDIVIDUAL_ID L:REF_CONTACT_AND_ADDRESS_ID T:CREATED/MODIFIED X:ESTABLISHMENTS L:ESTABLISHMENT_ID S:BUSINESS_NAME T:CREATED/MODIFIED X:ESTABLISHMENTS_CONTACT_AND_ADDRESS L:ESTABLISHMENT_CONTACT_AND_ADDRESS_ID L:REF_ESTABLISHMENT_ID L:REF_CONTACT_AND_ADDRESS_ID T:CREATED/MODIFIED X:ESTABLISHMENTS_OF_INDIVIDUALS L:ESTABLISHMENT_OF_INDIVIDUAL_ID L:REF_ESTABLISHMENT_ID L:REF_INDIVIDUAL_ID T:CREATED/MODIFIED X:CUSTOMERS L:CUSTOMER_ID L:REF_INDIVIDUAL_ID T:CREATED/MODIFIED X:PARTNERS L:PARTNER_ID L:REF_INDIVIDUAL_ID T:CREATED/MODIFIED X:EMPLOYEES_POSITIONS L:EMPLOYEE_POSITION_ID S:ROLE S:SPECIFIC_RULE S:HOWTODO T:CREATED/MODIFIED X:TIME_SCHEDULES L:TIME_SCHEDULE_ID S:APPLIED_TASK T:APPLIED_TIME L:REF_EMPLOYEE_POSITION_ID T:CREATED/MODIFIED X:EMPLOYEES L:EMPLOYEE_ID L:REF_INDIVIDUAL_ID L:REF_EMPLOYEE_POSITION_ID T:CREATED/MODIFIED GOOD LUCK, HOPE THIS HELPS. -Melvin Sudheer Satyanarayana [EMAIL PROTECTED] wrote: Hi, I'm creating an application for my web site. I want help in designing database tables. Currently I'm starting with user management system. The web site would have these types of users 1. Customer account 1a. Individual account. This user would be an individual with username, password, billing address, account security question, answer and few more fields. 1b. Business account. Each business account would have many users. Currently I have not decided the number of users for this type of account. It may be 10 users in the beginning. I want to keep an option to increase the number of users for business accounts. The business account will have, business name, billing address, account security question, answer, and few other business details. Each user within the account will have username, password, first name last name, mobile number and other personal details. 2. Partner account. These are similar to 1b business account type. 3. Internal account. These are employee accounts. Each user will have username, password, first name, last name, department, phone number and few other fields. Ideally how many tables should I create? What are the types of keys(primary and foreign) Other modules of the application I would be developing in the future are, contact management, shopping cart, mailing lists, customer support, etc. I have MySQL 4.1 on the server. Hope my question is clear. PS: I'm new to databases. Thanks for the help, Sudheer. S Binary Vibes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] - Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.
Re: Embedded MySQL
Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi [EMAIL PROTECTED] wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Embedded MySQL
I am sorry, this in case if your programming in java. Melvin Zamora [EMAIL PROTECTED] wrote: Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta.
Re: How To Pronounce MySQL
Or you can name it by your name JesseSql as long as you are in control :-) ...then no one would attempt claim Hey! thats my S-Q-L don't touch it. Its all yours. -Melvin Jesse [EMAIL PROTECTED] wrote: I guess perfectionism in a lot of what I do is a problem I've got to deal with. But I hate saying it one way and looking stupid when talking with real guru's. :-) Thanks, Jesse - Original Message - From: Peter Lauri To: 'Jesse' ; 'MySQL List' Sent: Thursday, June 08, 2006 3:34 AM Subject: RE: How To Pronounce MySQL Btw, better to ask and look stupid, then not to ask and be stupid... But this question does not give you a stupid look, more a look of a person seeking perfection :) -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Thursday, June 08, 2006 7:31 PM To: MySQL List Subject: How To Pronounce MySQL This may be a really stupid question, but I hate looking stupid if I can avoid it. :-) I have been using Microsoft SQL Server for a while, and I'm now trying to switch all our applications over to use MySQL. Microsoft SQL Server is pronounced Sequel Server. Is MySQL pronounced My Sequel, or is it pronounced My S-Q-L? I mean, generally speaking? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
I Have Problem with this Timestamp
Hi MySql Community, I put up a default null value TIMESTAMP on field type TIMESTAMP. Now I enter to the database as '-00-00 00:00:00' default for null value. From this on, I mapped it using hibernate with mysql-connector-java-3.1.6-bin.jar driver. I extract it but error occurred: Caused by: java.sql.SQLException: Cannot convert value '-00-00 00:00:00' from column 9 to TIMESTAMP. What did I done wrong? Is there a problem with the driver? Or should I use DATETIME instead? Some says the format is supposed to be '-00-00 00.00.00' instead, if so this would be a database problem, is this a some kind of unresovled bug? Lastly, any remedy for the meantime for this? Thanks a lot. Melvin R. Zamora - Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1cent;/min.
DB Tables on separate hardisks
Hi MySql, Would it be possible to have the PK tables on hardisk-A and FK tables on hardisk-B using only one database? to envision: CUSTOMER_MYSQL_DB CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B] -Melvin - Bring words and photos together (easily) with PhotoMail - it's free and works with Yahoo! Mail.