Best practice DB design for new Smart GWT application

[Blama]

Hi Isomorpic, Hi all

do you have best practices for SQL Database naming in order to reduce code when using the DB with Smart GWT?

One rule I found is the default sequence name used (with Oracle RDBMS). For a PK field

<DataSource 
	schema="myschema"
	dbName="Oracle"
	tableName="T_XYZ"
	ID="T_XYZ"
	serverType="sql">

	<fields>
		<field primaryKey="true" hidden="true" name="ID" type="sequence"></field>
	</fields>
</DataSource>

the name of the sequence used when not giving a specific name via "sequenceName" is "T_XYZ_ID" (see http://www.smartclient.com/smartgwte...l#sequenceName). So if possible, name the sequence that way.

Another rule would be to have only single-column PKs.

Do you have other best practices (only with respect to Smart GWT, not RDBMS Design in general)? E.g. Name PK column for table "X" always "ID" or "X_ID"?

Thank you,
Blama