メモ：書評システム　m_syuppan table のデータ構造

現在の書評システムの出版物DB表の中身です

フィールド名 型 長さ NOT NULL
cd_syuppan bpchar 10 NOT NULL
cd_syoseki bpchar 10 NOT NULL
dt_isbn bpchar 13
cd_media bpchar 2 NOT NULL
da_syohan bpchar 4
cd_series_gr bpchar 4
nm_level_gr int4 4
nm_series float4 4
cd_syuppansya bpchar 7
nm_vocabulary int4 4
nm_pageall int4 4
nm_tango int4 4
kb_tango bpchar 2
nm_gyogo int4 4
nm_pagegyo int4 4
nm_page_s int4 4
nm_page_e int4 4
nm_page_p int4 4
dt_moji float4 4
nm_yle float4 4
nm_yls float4 4
nm_osusume int4 4
kb_nenrei bpchar 2
cd_language bpchar 2 NOT NULL
nm_price float4 4
cd_money bpchar 2
nm_review int4 4 NOT NULL
nm_yl_a float4 4 NOT NULL
nm_osusume_a int4 4 NOT NULL
dt_size varchar 40
nm_vert int4 4
nm_horz int4 4
nm_thick int4 4
nm_weight int4 4
dt_jan1 varchar 13
dt_jan2 varchar 13
fg_edit bpchar 1 NOT NULL
cd_bunrui bpchar 2 NOT NULL
dt_biko varchar 254
dt_yobi1 varchar 40
dt_yobi2 varchar 40
dt_tuser varchar 8
dt_tpg varchar 40
dt_tdate timestamp 254 NOT NULL
dt_kuser varchar 8
dt_kpg varchar 40
dt_kdate timestamp 254 NOT NULL
fg_sakujyo bpchar 1 NOT NULL
dt_arasuji varchar 254
dt_series varchar 80
dt_syuppan varchar 120