Hi Madhu,
On 02/02/2011 17:46, Madhu Alagu wrote:
Hi
I am looking best model for the following tables:
-----
--- Table : groups_t
-----
CREATE TABLE groups_t
(
id BIGINT NOT NULL,
code VARCHAR NOT NULL,
version BIGINT NOT NULL
);
-----
--- Table : groups_i18n_t
-----
CREATE TABLE groups_i18n_t
(
group_id BIGINT NOT NULL,
lang_id BIGINT NOT NULL,
description TEXT NOT NULL,
version BIGINT NOT NULL
);
-----
--- Table : groups_lookup_t
-----
CREATE TABLE groups_lookup_t
(
group_id BIGINT NOT NULL,
lang_id BIGINT NOT NULL,
code VARCHAR NOT NULL,
description TEXT NOT NULL,
lookup_text TEXT NOT NULL
);
You might want to look at these threads.
i10n of data
internationalization of content
A few different approaches to this problem were discussed in them.
Werner
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
