上一主题: kwrd 对象下一主题: LONG_TEXTS 对象


loc 对象

对象详细信息如下:

关联的表:ca_location

工厂:default

REL_ATTR: id

公用名称:name

功能组:inventory

REST 操作:CREATE READ UPDATE

属性

数据库字段

数据类型

SREL 引用

标志

address1

address_1

STRING

 

 

address2

address_2

STRING

 

 

address3

address_3

STRING

 

 

address4

address_4

STRING

 

 

address5

address_5

STRING

 

 

address6

address_6

STRING

 

 

city

city

STRING

 

 

description

注释

STRING

 

 

contact_address_ flag

contact_address_ flag

integer

 

 

country

country

integer

ca_country id

 

county

county

STRING

 

 

creation_date

creation_date

LOCAL_TIME

 

 

creation_user

creation_user

STRING

 

 

delete_time

delete_time

LOCAL_TIME

 

 

exclude_ registration

exclude_ registration

integer

 

 

fax_number

fax_number

STRING

 

 

geo_coord_type

geo_coord_type

integer

 

 

geo_coords

geo_coords

STRING

 

 

delete_flag

非活动

integer

actbool enum

 

last_mod

last_update_date

LOCAL_TIME

 

 

last_update_user

last_update_user

STRING

 

 

name

location_name

STRING

 

 

id

location_uuid

UUID

 

UNIQUE REQUIRED KEY

mail_address_1

mail_address_1

STRING

 

 

mail_address_2

mail_address_2

STRING

 

 

mail_address_3

mail_address_3

STRING

 

 

mail_address_4

mail_address_4

STRING

 

 

mail_address_5

mail_address_5

STRING

 

 

mail_address_6

mail_address_6

STRING

 

 

pri_phone_number

pri_phone_number

STRING

 

 

primary_contact_uuid

primary_contact_uuid

UUID

 

 

site

site_id

integer

ca_site id

 

state

state

integer

ca_state_province ID

 

version_number

version_number

integer

 

 

zip

zip

STRING