View source | View content page | Page history | Printable version   

Projects:Translation Management/Development/Language Creation

Contents

Language Creation and Definition Documentation

This page is for the iteration covering language creation and definition as part of the Translation Management project. You will find information and design decisions regarding this user story here.

WAD

Language Table Schema

Name Primary Key Type Length Required Default Value Constraint
AD_LANGUAGE_ID * VARCHAR 32 true UNIQUE
AD_CLIENT_ID VARCHAR 32 true 0 = System FOREIGNKEY - AD_CLIENT
AD_ORG_ID VARCHAR 32 true 0 = * FOREIGNKEY - AD_ORG
ISACTIVE CHAR 1 true N ISACTIVE IN ('Y', 'N')
CREATED TIMESTAMP 7 true SYSDATE
CREATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
UPDATED TIMESTAMP 7 true SYSDATE
UPDATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
NAME VARCHAR 15 true ISOCODE_TRANSLATIONVERSION UNIQUE
AD_LANGUAGE VARCHAR 32 true FOREIGNKEY - AD_ISO_LANGUAGE_COUNTRY
ISOCODE VARCHAR 5 true
TRANSLATIONVERSION VARCHAR 10 false
ISBASELANGUAGE CHAR 1 true N ISACTIVE IN ('Y', 'N')
ISSYSTEMLANGUAGE CHAR 1 true N ISACTIVE IN ('Y', 'N')
ISMULTILANGUAGESUPPORT CHAR 1 true N ISACTIVE IN ('Y', 'N')
STATUS VARCHAR 30 false
STATISTICS VARCHAR 100 false
TRANSLATEDBY VARCHAR 255 false

ISO Country Table Schema

Name Primary Key Type Length Required Default Value Constraint
AD_COUNTRY_ID * VARCHAR 32 true UNIQUE
AD_CLIENT_ID VARCHAR 32 true 0 = System FOREIGNKEY - AD_CLIENT
AD_ORG_ID VARCHAR 32 true 0 = * FOREIGNKEY - AD_ORG
ISACTIVE CHAR 1 true N ISACTIVE IN ('Y', 'N')
CREATED TIMESTAMP 7 true SYSDATE
CREATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
UPDATED TIMESTAMP 7 true SYSDATE
UPDATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
NAME VARCHAR 100 true
ISO2LETTERCODE VARCHAR 2 true UNIQUE


ISO Language Table Schema

Name Primary Key Type Length Required Default Value Constraint
AD_LANGUAGE_ID * VARCHAR 32 true UNIQUE
AD_CLIENT_ID VARCHAR 32 true 0 = System FOREIGNKEY - AD_CLIENT
AD_ORG_ID VARCHAR 32 true 0 = * FOREIGNKEY - AD_ORG
ISACTIVE CHAR 1 true N ISACTIVE IN ('Y', 'N')
CREATED TIMESTAMP 7 true SYSDATE
CREATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
UPDATED TIMESTAMP 7 true SYSDATE
UPDATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
NAME VARCHAR 100 true
ISO2LETTERCODE VARCHAR 2 true UNIQUE


ISO Language Country Table Schema

Name Primary Key Type Length Required Default Value Constraint
AD_LANGUAGE_COUNTRY_ID * VARCHAR 32 true UNIQUE
AD_CLIENT_ID VARCHAR 32 true 0 = System FOREIGNKEY - AD_CLIENT
AD_ORG_ID VARCHAR 32 true 0 = * FOREIGNKEY - AD_ORG
ISACTIVE CHAR 1 true N ISACTIVE IN ('Y', 'N')
CREATED TIMESTAMP 7 true SYSDATE
CREATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
UPDATED TIMESTAMP 7 true SYSDATE
UPDATEDBY VARCHAR 32 true FOREIGNKEY - AD_USER
NAME VARCHAR 200 true
ISOCODE VARCHAR 5 true UNIQUE
AD_ISO_COUNTRY_ID VARCHAR 32 true FOREIGNKEY - AD_ISO_COUNTRY
AD_ISO_LANGUAGE_ID VARCHAR 32 true FOREIGNKEY - AD_ISO_LANGUAGE

Code

Callouts

The following artifacts have been created in the package org.openbravo.erpCommon.ad_callouts.

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Translation_Management/Development/Language_Creation"

This page has been accessed 3,609 times. This page was last modified on 8 June 2012, at 05:31. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.