ErogameScapeテーブル＆カラム一覧の実行結果

SQLの説明

ErogameScapeテーブル＆カラム一覧

検索結果

table_name	column_name	ordinal_position	data_type	is_nullable	column_default
amazon_game	id	1	integer	NO	nextval('amazon_game_id_seq'::regclass)
amazon_game	asin	2	text	NO
amazon_game	game	3	integer	NO
amazonlist	asin	1	text	NO
amazonlist	smallimage	2	text	YES
amazonlist	mediumimage	3	text	YES
amazonlist	largeimage	4	text	YES
amazonlist	binding	5	text	NO
amazonlist	brand	6	text	YES
amazonlist	ean	7	text	YES
amazonlist	releasedate	8	date	YES
amazonlist	title	9	text	NO
amazonlist	totalnew	10	integer	YES
amazonlist	totalused	11	integer	YES
amazonlist	totalcollectible	12	integer	YES
amazonlist	totalreviews	13	integer	YES
amazonlist	totalreviewpages	14	integer	YES
amazonlist	similarproduct_asin_1	15	text	YES
amazonlist	similarproduct_asin_2	16	text	YES
amazonlist	similarproduct_asin_3	17	text	YES
amazonlist	similarproduct_asin_4	18	text	YES
amazonlist	similarproduct_asin_5	19	text	YES
amazonlist	last_update_time	20	timestamp without time zone	YES
amazonlist	lowestnewprice	21	integer	YES
amazonlist	lowestusedprice	22	integer	YES
amazonlist	detailpageurl	23	text	YES
amazonmusiclist	asin	1	text	NO
amazonmusiclist	largeimage	2	text	NO
amazonmusiclist	binding	3	text	NO
amazonmusiclist	genre	4	text	YES
amazonmusiclist	productgroup	5	text	NO
amazonmusiclist	producttypename	6	text	NO
amazonmusiclist	releasedate	7	date	YES
amazonmusiclist	runningtime	8	integer	YES
amazonmusiclist	title	9	text	NO
amazonmusiclist	label	10	text	YES
amazonmusiclist	manufacturer	11	text	YES
amazonmusiclist	publisher	12	text	YES
amazonmusiclist	studio	13	text	YES
amazonmusiclist	created_at	14	timestamp without time zone	NO	now()
amazonmusiclist	updated_at	15	timestamp without time zone	NO	now()
appearance	actress	1	integer	NO
appearance	game	1	integer	NO
appearance	cid	2	text	NO
appearance	character	2	integer	NO
appearance	stage	3	integer	NO	1
appearance	update_at	3	date	NO	now()
appearance	role	4	integer	NO
appearance	order_number	5	integer	NO	100
appearance	netabare	6	boolean	NO	false
appearance	hscene	7	text	NO	''::text
appearance	url	8	text	NO	''::text
appearance	explanation	9	text	NO	''::text
appearance	formal_explanation	10	text	NO	''::text
appearance	age	11	text	NO	''::text
appearance	bust	12	text	NO	''::text
appearance	waist	13	text	NO	''::text
appearance	hip	14	text	NO	''::text
appearance	height	15	text	NO	''::text
appearance	weight	16	text	NO	''::text
appearance	cup	17	text	NO	''::text
appearance	created_at	18	timestamp without time zone	NO	now()
appearance	updated_at	19	timestamp without time zone	NO	now()
appearance_actor	game	1	integer	NO
appearance_actor	character	2	integer	NO
appearance_actor	stage	3	integer	NO
appearance_actor	actor	4	integer	NO
appearance_actor	ip	5	text	NO
appearance_actor	lock	6	boolean	NO	false
appearance_actor	created_at	7	timestamp without time zone	NO	now()
appearance_actor	updated_at	8	timestamp without time zone	NO	now()
appearance_eventimage_gyutto	game	1	integer	NO
appearance_eventimage_gyutto	character	2	integer	NO
appearance_eventimage_gyutto	stage	3	integer	NO
appearance_eventimage_gyutto	eventimage_dir	4	text	NO
appearance_eventimage_gyutto	created_at	5	timestamp without time zone	NO	now()
appearance_eventimage_gyutto	updated_at	6	timestamp without time zone	NO	now()
appearance_eventimage_gyutto	ip	7	text	NO	''::text
appearance_eventimage_gyutto	lock	8	boolean	NO	false
appearance_image_getchu	game	1	integer	NO
appearance_image_getchu	character	2	integer	NO
appearance_image_getchu	stage	3	integer	NO
appearance_image_getchu	image_dir	4	text	NO
appearance_image_getchu	created_at	5	timestamp without time zone	NO	now()
appearance_image_getchu	updated_at	6	timestamp without time zone	NO	now()
appearance_image_gyutto	game	1	integer	NO
appearance_image_gyutto	character	2	integer	NO
appearance_image_gyutto	stage	3	integer	NO
appearance_image_gyutto	image_dir	4	text	NO
appearance_image_gyutto	created_at	5	timestamp without time zone	NO	now()
appearance_image_gyutto	updated_at	6	timestamp without time zone	NO	now()
appearance_image_official	game	1	integer	NO
appearance_image_official	character	2	integer	NO
appearance_image_official	stage	3	integer	NO
appearance_image_official	image_dir	4	text	NO
appearance_image_official	created_at	5	timestamp without time zone	NO	now()
appearance_image_official	updated_at	6	timestamp without time zone	NO	now()
arrangement	id	1	integer	NO	nextval('bookstore.arrangement_id_seq'::regclass)
arrangement	music	1	integer	NO
arrangement	users_id	2	integer	NO
arrangement	creater	2	integer	NO
arrangement	created_at	3	timestamp without time zone	NO	now()
arrangement	group_id	3	integer	NO
arrangement	shelf_id	4	integer	NO
arrangement	updated_at	4	timestamp without time zone	NO	now()
arrangement	x	5	integer	NO
arrangement	volumes	6	integer	NO
arrangement	asin	7	text	NO
arrangement	z	8	integer	NO
arrangement	created	9	timestamp without time zone	NO	now()
arrangement	modified	10	timestamp without time zone	NO	now()
attributegroupsboolean	id	1	integer	NO	nextval(('"attributegroupsboolean_id_seq"'::text)::regclass)
attributegroupsboolean	game	2	integer	NO
attributegroupsboolean	attribute	3	integer	NO
attributegroupsboolean	boolean	4	boolean	NO
attributegroupsboolean	lock	5	boolean	YES	false
attributelist	id	1	integer	NO	nextval(('"attributelist_id_seq"'::text)::regclass)
attributelist	title	2	text	NO
attributelist	furigana	3	text	NO
attributelist	explain	4	text	YES
belong_to_gamegroup_list	id	1	integer	NO	nextval('belong_to_gamegroup_list_id_seq'::regclass)
belong_to_gamegroup_list	gamegroup	2	integer	NO
belong_to_gamegroup_list	game	3	integer	NO
belong_to_gamegroup_list	check_add	4	boolean	NO	false
belong_to_gamegroup_list	reservation_del	5	boolean	NO	false
belong_to_gamegroup_list	memo	6	text	YES
brandlist	id	1	integer	NO	nextval(('brandlist_id_seq'::text)::regclass)
brandlist	brandname	2	text	NO
brandlist	brandfurigana	3	text	NO
brandlist	makername	4	text	YES
brandlist	makerfurigana	5	text	YES
brandlist	url	6	text	YES
brandlist	checked	7	boolean	YES	false
brandlist	kind	8	text	YES	'CORPORATION'::text
brandlist	lost	9	boolean	YES	false
brandlist	directlink	10	boolean	YES	true
brandlist	median	11	integer	YES
brandlist	http_response_code	12	integer	YES
brandlist	twitter	13	text	YES
brandlist	twitter_data_widget_id	14	text	YES
brandlist	notes	15	text	YES
brandlist	erogetrailers	16	integer	YES
brandlist	cien	17	integer	YES
brandlist	review_private	18	boolean	NO	false
brandlist	count2	19	integer	YES
brandlist	count_all	20	integer	YES
brandlist	average2	21	integer	YES
brandlist	stdev	22	integer	YES
brandname_for_search	brand	1	integer	NO
brandname_for_search	name	2	text	NO
brandofficialinformation	game	1	integer	NO
brandofficialinformation	html	2	text	NO
brandofficialinformation	updatetimestamp	3	timestamp without time zone	NO	now()
campaign_game	id	1	integer	NO	nextval('campaign_game_id_seq'::regclass)
campaign_game	campaign	2	integer	NO
campaign_game	game	3	integer	NO
campaign_game	content	4	text	YES
campaign_game	url	5	text	YES
campaignlist	id	1	integer	NO	nextval('campaignlist_id_seq'::regclass)
campaignlist	store	2	integer	NO
campaignlist	name	3	text	NO
campaignlist	url	4	text	NO
campaignlist	start_timestamp	5	timestamp without time zone	YES
campaignlist	end_timestamp	6	timestamp without time zone	YES
campaignlist	content	7	text	NO
campaignlist	created_at	8	timestamp without time zone	NO	now()
campaignlist	index_end_timestamp	9	timestamp without time zone	YES
character_alias	id	1	integer	NO	nextval('character_alias_id_seq'::regclass)
character_alias	character	2	integer	NO
character_alias	name	3	text	NO	false
character_alias	furigana	4	text	NO	false
character_alias	netabare	5	boolean	NO	false
character_alias	created_at	6	timestamp without time zone	NO	now()
character_alias	updated_at	7	timestamp without time zone	NO	now()
character_music	music	1	integer	NO
character_music	character	2	integer	NO
character_music	created_at	3	timestamp without time zone	NO	now()
character_music	updated_at	4	timestamp without time zone	NO	now()
character_rolelist	id	1	integer	NO	nextval('character_rolelist_id_seq'::regclass)
character_rolelist	name	2	text	NO
characterlist	id	1	integer	NO	nextval('characterlist_id_seq'::regclass)
characterlist	name	2	text	NO
characterlist	furigana	3	text	NO
characterlist	sex	4	text	NO
characterlist	true_sex	5	text	NO
characterlist	bloodtype	6	text	NO
characterlist	birthday	7	text	NO
characterlist	explanation	8	text	NO	''::text
characterlist	created_at	9	timestamp without time zone	NO	now()
characterlist	updated_at	10	timestamp without time zone	NO	now()
characterlist	ragna	11	text	NO	''::text
composition	music	1	integer	NO
composition	creater	2	integer	NO
composition	created_at	3	timestamp without time zone	NO	now()
composition	updated_at	4	timestamp without time zone	NO	now()
connection_between_lists_of_games	id	1	integer	NO	nextval('connection_between_lists_of_games_id_seq'::regclass)
connection_between_lists_of_games	game_subject	2	integer	NO
connection_between_lists_of_games	game_object	3	integer	NO
connection_between_lists_of_games	reservation_del	4	boolean	NO	false
connection_between_lists_of_games	kind	5	text	NO
connection_between_lists_of_games	memo	6	text	YES
connection_between_lists_of_games	timestamp	7	timestamp without time zone	YES	('now'::text)::timestamp without time zone
connection_between_lists_of_games	freeze_flag	8	boolean	NO	false
connection_between_lists_of_games_history	id	1	integer	NO	nextval('connection_between_lists_of_games_history_id_seq'::regclass)
connection_between_lists_of_games_history	cg_id	2	integer	NO
connection_between_lists_of_games_history	game_subject	3	integer	NO
connection_between_lists_of_games_history	game_object	4	integer	NO
connection_between_lists_of_games_history	reservation_del	5	boolean	NO	false
connection_between_lists_of_games_history	kind	6	text	NO
connection_between_lists_of_games_history	memo	7	text	YES
connection_between_lists_of_games_history	timestamp	8	timestamp without time zone	YES
consumergamelist	id	1	integer	NO	nextval(('"consumergamelist_id_seq"'::text)::regclass)
consumergamelist	gamename	2	text	NO
consumergamelist	furigana	3	text	NO
consumergamelist	brandname	4	integer	NO
consumergamelist	sellday	5	date	YES
consumergamelist	model	6	text	NO
consumergamelist	genre	7	text	YES	'GAL'::text
consumerreview	id	1	integer	NO	nextval(('"consumerreview_id_seq"'::text)::regclass)
consumerreview	game	2	integer	NO
consumerreview	tokuten	3	integer	YES
consumerreview	tourokubi	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
consumerreviewpage	id	1	integer	NO	nextval(('"consumerreview_id_seq"'::text)::regclass)
consumerreviewpage	game	2	integer	NO
consumerreviewpage	tokuten	3	integer	YES
consumerreviewpage	tourokubi	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
consumerreviewpage	reviewpage	5	integer	NO
consumerreviewpage	memo	6	text	YES
consumerreviewuser	id	1	integer	NO	nextval(('"consumerreview_id_seq"'::text)::regclass)
consumerreviewuser	game	2	integer	NO
consumerreviewuser	tokuten	3	integer	YES
consumerreviewuser	tourokubi	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
consumerreviewuser	uid	5	text	NO
consumerreviewuser	memo_bak	6	character varying	YES
consumerreviewuser	hitokoto	7	text	YES
consumerreviewuser	netabare	8	boolean	YES	true
consumerreviewuser	memo	9	text	YES
creater_gyutto_author	creater	1	integer	NO
creater_gyutto_author	gyutto_author	2	integer	NO
creater_gyutto_author	created_at	3	timestamp without time zone	NO	now()
createrlist	id	1	integer	NO	nextval(('"createrlist_id_seq"'::text)::regclass)
createrlist	name	2	text	NO
createrlist	furigana	3	text	NO
createrlist	title	4	text	YES
createrlist	url	5	text	YES
createrlist	circle	6	text	YES
createrlist	betumei	7	integer	YES
createrlist	checked	8	boolean	YES	false
createrlist	twitter_username	9	text	YES
createrlist	twitter_id	10	integer	YES
createrlist	http_response_code	11	integer	YES
createrlist	blog	12	text	YES
createrlist	pixiv	13	integer	YES
createrlist	blog_title	14	text	YES
createrlist	facebook	15	text	YES
createrlist	syosetu	16	integer	YES
createrlist	syosetux	17	text	YES
createrlist	cien	18	integer	YES
createrlist	fantia	19	integer	YES
createrlist	pixivfanbox	20	text	YES
delete_arrangement	id	1	integer	NO	nextval('delete_arrangement_id_seq'::regclass)
delete_arrangement	music	2	integer	NO
delete_arrangement	creater	3	integer	NO
delete_arrangement	created_at	4	timestamp without time zone	NO	now()
delete_arrangement	checked	5	boolean	NO	false
delete_arrangement	reflection	6	boolean	NO	false
delete_arrangement	reason	7	text	NO	''::text
delete_composition	id	1	integer	NO	nextval('delete_composition_id_seq'::regclass)
delete_composition	music	2	integer	NO
delete_composition	creater	3	integer	NO
delete_composition	created_at	4	timestamp without time zone	NO	now()
delete_composition	checked	5	boolean	NO	false
delete_composition	reflection	6	boolean	NO	false
delete_composition	reason	7	text	NO	''::text
delete_game_music	id	1	integer	NO	nextval('delete_game_music_id_seq'::regclass)
delete_game_music	music	2	integer	NO
delete_game_music	game	3	integer	NO
delete_game_music	created_at	4	timestamp without time zone	NO	now()
delete_game_music	checked	5	boolean	NO	false
delete_game_music	reflection	6	boolean	NO	false
delete_game_music	reason	7	text	NO	''::text
delete_lyrics	id	1	integer	NO	nextval('delete_lyrics_id_seq'::regclass)
delete_lyrics	music	2	integer	NO
delete_lyrics	creater	3	integer	NO
delete_lyrics	created_at	4	timestamp without time zone	NO	now()
delete_lyrics	checked	5	boolean	NO	false
delete_lyrics	reflection	6	boolean	NO	false
delete_lyrics	reason	7	text	NO	''::text
delete_musicitem_music	id	1	integer	NO	nextval('delete_musicitem_music_id_seq'::regclass)
delete_musicitem_music	music	2	integer	NO
delete_musicitem_music	musicitem	3	integer	NO
delete_musicitem_music	created_at	4	timestamp without time zone	NO	now()
delete_musicitem_music	checked	5	boolean	NO	false
delete_musicitem_music	reflection	6	boolean	NO	false
delete_musicitem_music	comment	7	text	NO	''::text
delete_singer	id	1	integer	NO	nextval('delete_singer_id_seq'::regclass)
delete_singer	music	2	integer	NO
delete_singer	creater	3	integer	NO
delete_singer	created_at	4	timestamp without time zone	NO	now()
delete_singer	checked	5	boolean	NO	false
delete_singer	reflection	6	boolean	NO	false
delete_singer	reason	7	text	NO	''::text
douitujinbutu	creater1	1	integer	NO
douitujinbutu	creater2	2	integer	NO
erc_mistake_reviewpagelist	game	1	integer	NO
erc_mistake_reviewpagelist	reviewpage	2	integer	NO
erogetrailers_musicitem	erogetrailers	1	integer	NO
erogetrailers_musicitem	musicitem	2	integer	NO
erogetrailers_musicitem	created_at	3	timestamp without time zone	NO	now()
erogetrailers_musicitem	updated_at	4	timestamp without time zone	NO	now()
fanza_dlsofts	cid	1	text	NO
fanza_dlsofts	api_response_json	2	jsonb	NO
fanza_dlsofts	timestamp	3	timestamp without time zone	NO	now()
fanza_doujin_sales	cid	1	text	NO
fanza_doujin_sales	title	2	text	NO
fanza_doujin_sales	maker_id	3	integer	NO
fanza_doujin_sales	maker_name	4	text	NO
fanza_doujin_sales	price	5	integer	NO
fanza_doujin_sales	discount_rate	6	integer	NO
fanza_doujin_sales	img	7	text	NO
fanza_doujin_sales	genre	8	text	NO
fanza_doujin_sales	number_of_sales	9	integer	NO
fanza_doujin_sales	campaign_due_date	10	timestamp with time zone	NO
fanza_doujin_sales	create_date	11	date	NO	now()
fanza_doujin_sales	delivery_start_date	12	date	NO
fanza_doujin_sales	number_of_pages	13	integer	NO
fanza_doujin_sales	number_of_favorites	14	integer	NO	'-1'::integer
fanza_pack_dlsofts	fanza_packs_id	1	integer	NO
fanza_pack_dlsofts	cid	2	text	NO
fanza_pack_dlsofts	price	3	integer	YES	'-1'::integer
fanza_pack_dlsofts	sale	4	boolean	YES	false
fanza_pack_dlsofts	discount_rate	5	integer	YES	'-1'::integer
fanza_packs	id	1	integer	NO	nextval('fanza_packs_id_seq'::regclass)
fanza_packs	name	2	text	NO
fanza_packs	cid	3	text	NO
fanza_packs	price	4	integer	NO
fanza_packs	sale_start_timestamp	5	timestamp without time zone	NO
fanza_packs	sale_end_timestamp	6	timestamp without time zone	NO
favoritesite	uid	1	text	NO
favoritesite	reviewsite	2	integer	NO
favoritesite	syubetu	3	integer	YES
favoritesite	hitokoto	4	text	YES
game_banner_getchu_widesky	id	1	integer	NO	nextval('game_banner_getchu_widesky_id_seq'::regclass)
game_banner_getchu_widesky	game	2	integer	NO
game_banner_getchu_widesky	html	3	text	NO
game_music	music	1	integer	NO
game_music	game	2	integer	NO
game_music	category	3	text	NO
game_music	created_at	4	timestamp without time zone	NO	now()
game_music	updated_at	5	timestamp without time zone	NO	now()
game_preference_categories	id	1	integer	NO	nextval('game_preference_categories_id_seq'::regclass)
game_preference_categories	name	2	text	NO
game_preference_categories	furigana	3	text	NO
game_preference_group_categories	group_id	1	integer	NO
game_preference_group_categories	category_id	2	integer	NO
game_preference_group_categories	display_order	3	integer	NO	0
game_preference_groups	id	1	integer	NO	nextval('game_preference_groups_id_seq'::regclass)
game_preference_groups	name	2	text	NO
game_preference_groups	furigana	3	text	NO
game_preference_groups	uid	4	text	YES
game_preference_groups	created_at	5	timestamp without time zone	YES	CURRENT_TIMESTAMP
game_store_sp	id	1	integer	NO	nextval('game_store_sp_id_seq'::regclass)
game_store_sp	store	2	integer	NO
game_store_sp	game	3	integer	NO
game_store_sp	store_id_1	4	text	YES
game_store_sp	store_id_2	5	text	YES
game_store_sp	itemname	6	text	YES
game_store_sp	sellday	7	date	YES
game_store_sp	price	8	integer	YES
game_store_sp	price_date	9	date	YES
game_store_sp	timestamp	10	timestamp without time zone	NO	now()
gamegrouplist	id	1	integer	NO	nextval('gamegrouplist_id_seq'::regclass)
gamegrouplist	name	2	text	NO
gamegrouplist	furigana	3	text	NO
gamegrouplist	median	4	integer	YES
gamegrouplist	check_add	5	boolean	NO	false
gamelist	id	1	integer	NO	nextval(('gamelist_id_seq'::text)::regclass)
gamelist	gamename	2	text	NO
gamelist	furigana	3	text	NO
gamelist	sellday	4	date	YES	'2030-01-01'::date
gamelist	brandname	5	integer	YES
gamelist	median	6	integer	YES
gamelist	stdev	7	integer	YES
gamelist	creater	8	integer	YES
gamelist	kansouurl	9	text	YES
gamelist	checked	10	boolean	YES	false
gamelist	hanbaisuu	11	integer	YES
gamelist	average2	12	integer	YES
gamelist	median2	13	integer	YES
gamelist	count2	14	integer	YES
gamelist	comike	15	text	YES
gamelist	shoukai	16	text	YES
gamelist	model	17	text	YES	'PC'::text
gamelist	checked2	18	boolean	YES	false
gamelist	erogame	19	boolean	YES	true
gamelist	galge	20	text	YES
gamelist	elfics	21	text	YES
gamelist	banner_url	22	text	YES
gamelist	admin_checked	23	boolean	YES
gamelist	max2	24	integer	YES
gamelist	min2	25	integer	YES
gamelist	gyutto_enc	26	text	YES
gamelist	gyutto_id	27	character varying	YES
gamelist	dmm	28	text	YES
gamelist	dmm_genre	29	text	YES
gamelist	dmm_genre_2	30	text	YES
gamelist	erogametokuten	31	integer	YES
gamelist	total_play_time_median	32	integer	YES
gamelist	time_before_understanding_fun_median	33	integer	YES
gamelist	dlsite_id	34	text	YES
gamelist	dlsite_domain	35	text	YES
gamelist	the_number_of_uid_which_input_pov	36	integer	YES
gamelist	the_number_of_uid_which_input_play	37	integer	YES
gamelist	total_pov_enrollment_of_a	38	integer	YES
gamelist	total_pov_enrollment_of_b	39	integer	YES
gamelist	total_pov_enrollment_of_c	40	integer	YES
gamelist	trial_url	41	text	YES
gamelist	trial_h	42	boolean	YES
gamelist	http_response_code	43	integer	YES
gamelist	okazu	44	boolean	YES
gamelist	axis_of_soft_or_hard	45	integer	YES
gamelist	trial_url_update_time	46	timestamp without time zone	NO	'0001-01-01 00:00:00'::timestamp without time zone
gamelist	genre	47	text	YES
gamelist	twitter	48	text	YES
gamelist	erogetrailers	49	integer	NO	0
gamelist	tourokubi	50	date	YES	now()
gamelist	digiket	51	text	YES
gamelist	dmm_sample_image_count	52	integer	YES	'-1'::integer
gamelist	dlsite_sample_image_count	53	integer	YES	'-1'::integer
gamelist	gyutto_sample_image_count	54	integer	YES	'-1'::integer
gamelist	digiket_sample_image_count	55	integer	YES	'-1'::integer
gamelist	twitter_search	56	text	YES
gamelist	tgfrontier	57	integer	NO	0
gamelist	gamemeter	58	text	YES
gamelist	twitter_data_widget_id	59	text	YES
gamelist	twitter_data_widget_id_before	60	text	YES
gamelist	twitter_data_widget_id_official	61	text	YES
gamelist	masterup	62	date	YES
gamelist	masterup_tourokubi	63	timestamp without time zone	YES
gamelist	steam	64	integer	YES
gamelist	dlsite_rental	65	boolean	YES	false
gamelist	dmm_subsc	66	text	YES
gamelist	surugaya_1	67	integer	NO	0
gamelist	surugaya_2	68	integer	NO	0
gamelist	surugaya_1_back_image	69	boolean	NO	false
gamelist	surugaya_2_back_image	70	boolean	NO	false
gamelist	count_all	71	integer	YES
gamelist	playrack	72	integer	NO	0
gamelist	vndb	73	text	YES
gamelist	moepedia	74	integer	NO	0
gamelist	hbox_link	75	text	YES
gamelist	hbox_id	76	integer	NO	0
gamelist	emdb	77	text	YES
gamelist	review_private	78	boolean	NO	false
gamelist_masterup_update	id	1	integer	NO	nextval('gamelist_masterup_update_id_seq'::regclass)
gamelist_masterup_update	game	2	integer	NO
gamelist_masterup_update	masterup	3	date	NO
gamelist_masterup_update	timestamp	4	timestamp without time zone	YES	now()
gamelist_sellday_update	id	1	integer	NO	nextval('gamelist_sellday_update_id_seq'::regclass)
gamelist_sellday_update	game	2	integer	NO
gamelist_sellday_update	sellday_old	3	date	NO
gamelist_sellday_update	sellday_new	4	date	NO
gamelist_sellday_update	timestamp	5	timestamp without time zone	YES	now()
genrelist	genre	1	text	NO
genrelist	furigana	2	text	NO
hanbaisuu	game	1	integer	NO
hanbaisuu	startdate	2	date	NO
hanbaisuu	enddate	3	date	NO
hanbaisuu	hanbaisuu	4	integer	NO
holyseal	id	1	integer	NO	nextval('holyseal_id_seq'::regclass)
holyseal	game	2	integer	NO
holyseal	holyseal_id	3	integer	NO
item_game	item	1	integer	NO
item_game	game	2	integer	NO
item_new_price	item_store_id	1	integer	NO
item_new_price	price	2	integer	NO
item_new_price	timestamp	3	timestamp without time zone	NO	now()
item_store	item	1	integer	NO
item_store	store	2	integer	NO
item_store	id_of_store	3	text	NO
item_store	genre_1	4	text	YES
item_store	genre_2	5	text	YES
item_store	privilege_content	6	text	YES
item_store	id	7	integer	NO	nextval('item_store_id_seq'::regclass)
item_store	privilege	8	boolean	NO	false
item_used_price	item_store_id	1	integer	NO
item_used_price	price	2	integer	NO
item_used_price	timestamp	3	timestamp without time zone	NO	now()
itemgroups	item_parent	1	integer	NO
itemgroups	item_children	2	integer	NO
itemgroups	memo	3	text	YES
itemlist	id	1	integer	NO	nextval('itemlist_id_seq'::regclass)
itemlist	name	2	text	NO
itemlist	jan	3	text	NO	0
itemlist	fixedprice	4	integer	NO	0
itemlist	sellform	5	text	NO	'PKG'::text
itemlist	edition	6	text	NO	'Limited'::text
itemlist	media	7	text	YES
itemlist	memo	8	text	YES
itemlist	releasedate	9	date	NO	'3000-01-01'::date
itemlist	timestamp	10	timestamp without time zone	NO	now()
itemlist	fixedprice_after_taxes	11	integer	YES	0
junirirekiavgtenpersent	game	1	integer	NO
junirirekiavgtenpersent	date	2	date	NO
junirirekiavgtenpersent	avg	3	real	NO
junirirekiavgtenpersent	count	4	integer	NO
junirirekiavgtenpersent	junni	5	integer	YES
junirirekiavgtenpersent	junni_old	6	integer	YES
junirirekimedian	game	1	integer	NO
junirirekimedian	date	2	date	NO
junirirekimedian	count	3	integer	NO
junirirekimedian	median	4	integer	NO
junirirekimedian	junni	5	integer	YES
junirirekimedian	junni_old	6	integer	YES
junirirekimedian_sites	id	1	integer	NO	nextval('junirirekimedian_sites_id_seq'::regclass)
junirirekimedian_sites	date	2	date	NO
junirirekimedian_sites	title	3	text	NO
junirirekimedian_sites	url	4	text	NO
junirirekimedian_sites	homepage_id	5	integer	NO
junnirireki	game	1	integer	NO
junnirireki	date	2	date	NO
junnirireki	avg	3	real	NO
junnirireki	count	4	integer	NO
junnirireki	junni	5	integer	NO
junnirireki	junni_old	6	integer	YES
karaoke_damlist	music	1	integer	NO
karaoke_damlist	no	2	text	NO
karaoke_damlist	name	3	text	NO
karaoke_damlist	created_at	4	timestamp without time zone	NO	now()
karaoke_damlist	updated_at	5	timestamp without time zone	NO	now()
karaoke_joysound	music	1	integer	NO
karaoke_joysound	no	2	text	NO
karaoke_joysound	name	3	text	NO
karaoke_joysound	created_at	4	timestamp without time zone	NO	now()
karaoke_joysound	updated_at	5	timestamp without time zone	NO	now()
lyrics	music	1	integer	NO
lyrics	creater	2	integer	NO
lyrics	created_at	3	timestamp without time zone	NO	now()
lyrics	updated_at	4	timestamp without time zone	NO	now()
mod_appearance	id	1	integer	NO	nextval('mod_appearance_id_seq'::regclass)
mod_appearance	game	2	integer	NO
mod_appearance	character	3	integer	NO
mod_appearance	stage	4	integer	NO	1
mod_appearance	role	5	integer	NO
mod_appearance	order_number	6	integer	NO	100
mod_appearance	netabare	7	boolean	NO	false
mod_appearance	hscene	8	text	NO	''::text
mod_appearance	url	9	text	NO	''::text
mod_appearance	explanation	10	text	NO	''::text
mod_appearance	formal_explanation	11	text	NO	''::text
mod_appearance	age	12	text	NO	''::text
mod_appearance	bust	13	text	NO	''::text
mod_appearance	waist	14	text	NO	''::text
mod_appearance	hip	15	text	NO	''::text
mod_appearance	height	16	text	NO	''::text
mod_appearance	weight	17	text	NO	''::text
mod_appearance	cup	18	text	NO	''::text
mod_appearance	ip	19	text	NO
mod_appearance	created_at	20	timestamp without time zone	NO	now()
mod_appearance	checked	21	boolean	NO	false
mod_appearance	reflection	22	boolean	NO	false
mod_appearance	remarks	23	text	NO	''::text
mod_appearance	delete	24	boolean	NO	false
mod_appearance	gyutto_image_dir	25	text	NO	''::text
mod_appearance	creater	26	text	NO	''::text
mod_appearance	getchu_image_dir	27	text	NO	''::text
mod_appearance	official_image_dir	28	text	NO	''::text
mod_attributegroupsboolean	id	1	integer	NO	nextval('mod_attributegroupsboolean_id_seq'::regclass)
mod_attributegroupsboolean	no	2	integer	NO
mod_attributegroupsboolean	game	3	integer	NO
mod_attributegroupsboolean	attribute	4	integer	NO
mod_attributegroupsboolean	boolean	5	boolean	NO
mod_attributegroupsboolean	checked	6	boolean	NO	false
mod_attributegroupsboolean	timestamp	7	timestamp without time zone	NO	now()
mod_attributegroupsboolean	ip	8	text	NO
mod_brandlist	id	1	integer	NO	nextval('mod_brandlist_id_seq'::regclass)
mod_brandlist	brand	2	integer	NO
mod_brandlist	brandname	3	text	YES
mod_brandlist	furigana	4	text	YES
mod_brandlist	url	5	text	YES
mod_brandlist	bikou	6	text	YES
mod_brandlist	checked	7	boolean	YES	false
mod_brandlist	timestamp	8	timestamp without time zone	YES	('now'::text)::timestamp without time zone
mod_brandlist	kind	9	text	YES
mod_brandlist	lost	10	boolean	YES	false
mod_brandlist	directlink	11	boolean	YES	true
mod_brandlist	twitter	12	text	YES
mod_brandlist	erogetrailers	13	integer	YES
mod_brandlist	cien	14	integer	YES
mod_character_alias	id	1	integer	NO	nextval('mod_character_alias_id_seq'::regclass)
mod_character_alias	character_alias	2	integer	NO
mod_character_alias	name	3	text	NO
mod_character_alias	furigana	4	text	NO
mod_character_alias	netabare	5	boolean	NO	false
mod_character_alias	remarks	6	text	NO	''::text
mod_character_alias	ip	7	text	NO
mod_character_alias	created_at	8	timestamp without time zone	NO	now()
mod_character_alias	checked	9	boolean	NO	false
mod_character_alias	reflection	10	boolean	NO	false
mod_character_alias	delete	11	boolean	NO	false
mod_character_alias_insert	id	1	integer	NO	nextval('mod_character_alias_insert_id_seq'::regclass)
mod_character_alias_insert	character	2	integer	NO
mod_character_alias_insert	name	3	text	NO
mod_character_alias_insert	furigana	4	text	NO
mod_character_alias_insert	netabare	5	boolean	NO	false
mod_character_alias_insert	created_at	6	timestamp without time zone	NO	now()
mod_character_alias_insert	checked	7	boolean	YES	false
mod_characterlist	id	1	integer	NO	nextval('mod_characterlist_id_seq'::regclass)
mod_characterlist	character	2	integer	NO
mod_characterlist	name	3	text	NO
mod_characterlist	furigana	4	text	NO
mod_characterlist	sex	5	text	NO
mod_characterlist	true_sex	6	text	NO
mod_characterlist	bloodtype	7	text	NO
mod_characterlist	birthday	8	text	NO
mod_characterlist	explanation	9	text	NO	''::text
mod_characterlist	remarks	10	text	NO	''::text
mod_characterlist	ip	11	text	NO
mod_characterlist	created_at	12	timestamp without time zone	NO	now()
mod_characterlist	checked	13	boolean	NO	false
mod_characterlist	reflection	14	boolean	NO	false
mod_characterlist	delete	15	boolean	NO	false
mod_characterlist	ragna	16	text	NO	''::text
mod_createrlist	id	1	integer	NO	nextval('mod_createrlist_id_seq'::regclass)
mod_createrlist	creater	2	integer	NO
mod_createrlist	name	3	text	YES
mod_createrlist	furigana	4	text	YES
mod_createrlist	title	5	text	YES
mod_createrlist	url	6	text	YES
mod_createrlist	circle	7	text	YES
mod_createrlist	bikou	8	text	YES
mod_createrlist	checked	9	boolean	YES	false
mod_createrlist	timestamp	10	timestamp without time zone	YES	('now'::text)::timestamp without time zone
mod_createrlist	twitter_id	11	integer	YES
mod_createrlist	twitter_username	12	text	YES
mod_createrlist	blog	13	text	YES
mod_createrlist	blog_title	14	text	YES
mod_createrlist	pixiv	15	integer	YES
mod_createrlist	ip	16	text	YES
mod_createrlist	facebook	17	text	YES
mod_createrlist	syosetu	18	integer	YES
mod_createrlist	syosetux	19	text	YES
mod_createrlist	cien	20	integer	YES
mod_createrlist	fantia	21	integer	YES
mod_createrlist	pixivfanbox	22	text	YES
mod_game_music	id	1	integer	NO	nextval('mod_game_music_id_seq'::regclass)
mod_game_music	music	2	integer	NO
mod_game_music	game	3	integer	NO
mod_game_music	category	4	text	NO
mod_game_music	created_at	5	timestamp without time zone	NO	now()
mod_game_music	checked	6	boolean	NO	false
mod_game_music	reflection	7	boolean	NO	false
mod_gamelist	id	1	integer	NO	nextval('mod_gamelist_id_seq'::regclass)
mod_gamelist	game	2	integer	NO
mod_gamelist	gamename	3	text	YES
mod_gamelist	furigana	4	text	YES
mod_gamelist	sellday	5	date	YES
mod_gamelist	comike	6	text	YES
mod_gamelist	shoukai	7	text	YES
mod_gamelist	model	8	text	YES
mod_gamelist	checked	9	boolean	YES	false
mod_gamelist	timestamp	10	timestamp without time zone	YES	('now'::text)::timestamp without time zone
mod_gamelist	bikou	11	text	YES
mod_gamelist	galge	12	text	YES
mod_gamelist	erogame	13	boolean	YES
mod_gamelist	holyseal	14	integer	YES
mod_gamelist	holyseal1	15	integer	YES
mod_gamelist	holyseal2	16	integer	YES
mod_gamelist	amazon	17	text	YES
mod_gamelist	amazon1	18	text	YES
mod_gamelist	amazon2	19	text	YES
mod_gamelist	amazon3	20	text	YES
mod_gamelist	banner_url	21	text	YES
mod_gamelist	gyutto	22	character varying	YES
mod_gamelist	dmm	23	text	YES
mod_gamelist	ip	24	text	YES
mod_gamelist	dmm_genre	25	text	YES
mod_gamelist	dmm_genre_2	26	text	YES
mod_gamelist	erogametokuten	27	integer	YES
mod_gamelist	dlsite_id	28	text	YES
mod_gamelist	dlsite_domain	29	text	YES
mod_gamelist	trial_h	30	boolean	YES
mod_gamelist	trial_url	31	text	YES
mod_gamelist	okazu	32	boolean	YES
mod_gamelist	axis_of_soft_or_hard	33	integer	YES
mod_gamelist	genre	34	text	YES
mod_gamelist	twitter	35	text	YES
mod_gamelist	erogetrailers	36	integer	YES
mod_gamelist	digiket	37	text	YES
mod_gamelist	tgfrontier	38	integer	YES
mod_gamelist	gamemeter	39	text	YES
mod_gamelist	masterup	40	date	YES
mod_gamelist	masterup_source_url	41	text	YES
mod_gamelist	steam	42	integer	YES
mod_gamelist	dlsite_rental	43	boolean	YES
mod_gamelist	surugaya_1	44	integer	NO	0
mod_gamelist	surugaya_2	45	integer	NO	0
mod_gamelist	ooparts_1	46	text	YES
mod_gamelist	playrack	47	integer	NO	0
mod_gamelist	vndb	48	text	YES
mod_gamelist	moepedia	49	integer	NO	0
mod_gamelist	emdb	50	text	YES
mod_musicitem_othereditionlist	id	1	integer	NO	nextval('mod_musicitem_othereditionlist_id_seq'::regclass)
mod_musicitem_othereditionlist	musicitem	2	integer	NO
mod_musicitem_othereditionlist	edition	3	text	NO
mod_musicitem_othereditionlist	information	4	text	YES
mod_musicitem_othereditionlist	ohp	5	text	YES
mod_musicitem_othereditionlist	jan	6	text	YES
mod_musicitem_othereditionlist	stocknumber	7	text	YES
mod_musicitem_othereditionlist	created_at	8	timestamp without time zone	NO	now()
mod_musicitem_othereditionlist	checked	9	boolean	NO	false
mod_musicitem_othereditionlist	reflection	10	boolean	NO	false
mod_musicitem_othereditionlist	delete	11	boolean	NO	false
mod_musicitemlist	id	1	integer	NO	nextval('mod_musicitemlist_id_seq'::regclass)
mod_musicitemlist	musicitem	2	integer	NO
mod_musicitemlist	name	3	text	NO
mod_musicitemlist	furigana	4	text	NO
mod_musicitemlist	category	5	text	NO
mod_musicitemlist	media	6	text	YES
mod_musicitemlist	information	7	text	YES
mod_musicitemlist	ohp	8	text	YES
mod_musicitemlist	jan	9	text	YES
mod_musicitemlist	stocknumber	10	text	YES
mod_musicitemlist	releasedate	11	date	YES
mod_musicitemlist	remarks	12	text	YES
mod_musicitemlist	gyutto	13	integer	YES
mod_musicitemlist	asin	14	text	YES
mod_musicitemlist	ip	15	text	NO
mod_musicitemlist	created_at	16	timestamp without time zone	NO	now()
mod_musicitemlist	checked	17	boolean	NO	false
mod_musicitemlist	reflection	18	boolean	NO	false
mod_musicitemlist	delete	19	boolean	NO	false
mod_musicitemlist	dmm_dl	20	text	YES
mod_musiclist	id	1	integer	NO	nextval('mod_musiclist_id_seq'::regclass)
mod_musiclist	music	2	integer	NO
mod_musiclist	name	3	text	NO
mod_musiclist	furigana	4	text	NO
mod_musiclist	playtime	5	interval	YES
mod_musiclist	vocal	6	boolean	NO
mod_musiclist	ohp	7	text	YES
mod_musiclist	releasedate	8	date	YES
mod_musiclist	erogetrailers	9	integer	YES
mod_musiclist	memo	10	text	YES
mod_musiclist	remarks	11	text	YES
mod_musiclist	ip	12	text	NO
mod_musiclist	created_at	13	timestamp without time zone	NO	now()
mod_musiclist	checked	14	boolean	NO	false
mod_musiclist	reflection	15	boolean	NO	false
mod_musiclist	delete	16	boolean	NO	false
mod_shokushu	id	1	integer	NO	nextval('mod_shokushu_id_seq'::regclass)
mod_shokushu	shokushu_id	2	integer	NO
mod_shokushu	shubetu	3	integer	NO
mod_shokushu	shubetu_detail	4	integer	NO
mod_shokushu	shubetu_detail_name	5	text	YES
mod_shokushu	delete_flag	6	boolean	YES	false
mod_shokushu	cancel_flag	7	boolean	YES	false
mod_shokushu	reflect_flag	8	boolean	YES	false
mod_shokushu	bikou	9	text	YES
mod_shokushu	timestamp	10	timestamp without time zone	YES	('now'::text)::timestamp without time zone
mod_shokushu	ip	11	text	YES
mod_shokushu	cancel_ip	12	text	YES
mod_shokushu	cancel_reason	13	text	YES
mod_shokushu	cancel_timestamp	14	timestamp without time zone	YES
mod_singer	id	1	integer	NO	nextval('mod_singer_id_seq'::regclass)
mod_singer	music	2	integer	NO
mod_singer	creater	3	integer	NO
mod_singer	name	4	text	NO	''::text
mod_singer	featuring	5	boolean	NO	false
mod_singer	created_at	6	timestamp without time zone	NO	now()
mod_singer	checked	7	boolean	NO	false
mod_singer	reflection	8	boolean	NO	false
mod_stage	id	1	integer	NO	nextval('mod_stage_id_seq'::regclass)
mod_stage	game	2	integer	NO
mod_stage	stage	3	integer	NO
mod_stage	name	4	text	NO
mod_stage	explanation	5	text	NO	''::text
mod_stage	ip	6	text	NO
mod_stage	checked	7	boolean	NO	false
mod_stage	created_at	8	timestamp without time zone	NO	now()
mod_stage	remark	9	text	NO	''::text
mod_stage	reflection	10	boolean	NO	false
mod_stage	order_number	11	integer	NO	100
modellist	modelname	1	text	NO
modellist	furigana	2	text	NO
modellist	officialmodelname	3	text	NO
modellist	officialfurigana	4	text	NO
modellist	maker	5	text	YES
musicitem_amazon	musicitem	1	integer	NO
musicitem_amazon	asin	2	text	NO
musicitem_amazon	created_at	3	timestamp without time zone	NO	now()
musicitem_dmm	musicitem	1	integer	NO
musicitem_dmm	genre1	2	text	NO
musicitem_dmm	genre2	3	text	NO
musicitem_dmm	cid	4	text	NO
musicitem_dmm	created_at	5	timestamp without time zone	NO	now()
musicitem_dmm_dl	musicitem	1	integer	NO
musicitem_dmm_dl	cid	2	text	NO
musicitem_dmm_dl	created_at	3	timestamp without time zone	NO	now()
musicitem_gyutto	musicitem	1	integer	NO
musicitem_gyutto	gyutto	2	integer	NO
musicitem_gyutto	created_at	3	timestamp without time zone	NO	now()
musicitem_music	music	1	integer	NO
musicitem_music	musicitem	2	integer	NO
musicitem_music	disk_number	3	integer	NO
musicitem_music	track_number	4	integer	NO
musicitem_music	created_at	5	timestamp without time zone	NO	now()
musicitem_music	updated_at	6	timestamp without time zone	NO	now()
musicitem_othereditionlist	musicitem	1	integer	NO
musicitem_othereditionlist	edition	2	text	NO
musicitem_othereditionlist	information	3	text	YES
musicitem_othereditionlist	ohp	4	text	YES
musicitem_othereditionlist	jan	5	text	YES
musicitem_othereditionlist	stocknumber	6	text	YES
musicitem_othereditionlist	created_at	7	timestamp without time zone	NO	now()
musicitem_othereditionlist	updated_at	8	timestamp without time zone	NO	now()
musicitemlist	id	1	integer	NO	nextval('musicitemlist_id_seq'::regclass)
musicitemlist	name	2	text	NO
musicitemlist	furigana	3	text	NO
musicitemlist	category	4	text	NO
musicitemlist	information	5	text	YES
musicitemlist	ohp	6	text	YES
musicitemlist	jan	7	text	YES
musicitemlist	stocknumber	8	text	YES
musicitemlist	releasedate	9	date	YES
musicitemlist	created_at	10	timestamp without time zone	NO	now()
musicitemlist	updated_at	11	timestamp without time zone	NO	now()
musiclist	id	1	integer	NO	nextval('musiclist_id_seq'::regclass)
musiclist	name	2	text	NO
musiclist	furigana	3	text	NO
musiclist	playtime	4	interval	YES
musiclist	vocal	5	boolean	NO
musiclist	ohp	6	text	YES
musiclist	releasedate	7	date	YES
musiclist	erogetrailers	8	integer	YES
musiclist	memo	9	text	YES
musiclist	created_at	10	timestamp without time zone	NO	now()
musiclist	updated_at	11	timestamp without time zone	NO	now()
musiclist	user_insert	12	boolean	NO	true
musiclist	gyutto_check	13	boolean	NO	false
myuser_preference	uid	1	text	NO
myuser_preference	preference_group	2	integer	NO
myuser_preference	self_view	3	boolean	YES	false
old_reviewpagelist	id	1	integer	NO
old_reviewpagelist	game	2	integer	NO
old_reviewpagelist	reviewpage	3	integer	NO
old_reviewpagelist	tokuten	4	integer	YES
old_reviewpagelist	tourokubi	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone
old_reviewpagelist	memo	6	text	YES
ooparts	id	1	text	NO
ooparts	gamename	2	text	NO
ooparts	release_date	3	timestamp with time zone	NO	'2020-04-24 00:00:00+09'::timestamp with time zone
ooparts	closing_date	4	timestamp with time zone	NO	'2200-01-01 00:00:00+09'::timestamp with time zone
ooparts_game	ooparts	1	text	NO
ooparts_game	game	2	integer	NO
ooparts_game	timestamp	3	timestamp with time zone	NO	now()
platformlist	id	1	integer	NO	nextval('platformlist_id_seq'::regclass)
platformlist	name	2	text	YES
platformlist	sort	3	integer	YES
platformlist	model	4	text	YES	'PC'::text
pov_judgment	id	1	integer	NO	nextval(('"pov_judgment_id_seq"'::text)::regclass)
pov_judgment	uid	2	text	NO
pov_judgment	pov	3	integer	NO
pov_judgment	judgment	4	text	NO
pov_judgment	hitokoto	5	text	YES
pov_judgment	timestamp	6	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povadjust	id	1	integer	NO	nextval(('"povadjust_id_seq"'::text)::regclass)
povadjust	pov1	2	integer	NO
povadjust	pov2	3	integer	YES
povadjust	handle	4	text	YES
povadjust	hitokoto	5	text	YES
povadjust	transaction	6	text	NO
povadjust_res	id	1	integer	NO	nextval(('"povadjust_res_id_seq"'::text)::regclass)
povadjust_res	pov1	2	integer	NO
povadjust_res	pov2	3	integer	YES
povadjust_res	handle	4	text	YES
povadjust_res	hitokoto	5	text	NO
povadjust_res	timestamp	6	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povadjust_res	transaction	7	text	YES
povadjust_res_hiroin	id	1	integer	NO	nextval(('"povadjust_res_hiroin_id_seq"'::text)::regclass)
povadjust_res_hiroin	pov1	2	integer	NO
povadjust_res_hiroin	pov2	3	integer	NO
povadjust_res_hiroin	result	4	boolean	NO
povadjust_res_hiroin	hitokoto	5	text	NO
povgroups	id	1	integer	NO	nextval(('"povgroups_id_seq"'::text)::regclass)
povgroups	uid	2	text	NO
povgroups	pov	3	integer	NO
povgroups	game	4	integer	NO
povgroups	rank	5	character	NO
povgroups	memo	6	text	YES
povgroups	tourokubi	7	timestamp with time zone	YES	now()
povgroups	sage	8	boolean	YES	false
povgroups	modified	9	timestamp without time zone	YES	now()
povgroups_before	id	1	integer	NO	nextval('povgroups_before_id_seq'::regclass)
povgroups_before	uid	2	text	NO
povgroups_before	pov	3	integer	NO
povgroups_before	game	4	integer	NO
povgroups_before	rank	5	character	NO
povgroups_before	memo	6	text	YES
povgroups_before	tourokubi	7	timestamp without time zone	NO	now()
povgroups_before	sage	8	boolean	NO	false
povgroups_netabare	pg_id	1	integer	NO
povgroups_netabare	voter_uid	2	text	NO
povgroups_netabare	yes_no	3	boolean	NO
povgroups_netabare	timestamp	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povgroups_netabare	reason	5	text	YES
povgroups_touhyou	pg_id	1	integer	NO
povgroups_touhyou	voter_uid	2	text	NO
povgroups_touhyou	hitokoto	3	text	YES
povgroups_touhyou	timestamp	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povgroups_toukei	pov	1	integer	NO
povgroups_toukei	game	2	integer	NO
povgroups_toukei	rank	3	character	NO
povgroups_toukei	count	4	integer	NO
povlist	id	1	integer	NO	nextval(('"povlist_id_seq"'::text)::regclass)
povlist	title	2	character varying	NO
povlist	comment	3	text	NO
povlist	uid	4	text	NO
povlist	timestamp	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povlist	tourokubi	6	timestamp with time zone	YES
povlist	furigana	7	text	YES
povlist	editingday	8	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povlist	registration	9	boolean	YES	false
povlist	system_title	10	text	YES
povlist	system_group	11	text	YES	'未分類'::text
povlist	netabare	12	boolean	YES	false
povlist	number_of_user	13	integer	YES
povlist	before	14	boolean	NO	false
povlist	before_trial	15	boolean	NO	false
povlist_edit_log	id	1	integer	NO	nextval(('"povlist_edit_log_id_seq"'::text)::regclass)
povlist_edit_log	pov	2	integer	NO
povlist_edit_log	title	3	character varying	NO
povlist_edit_log	comment	4	text	NO
povlist_edit_log	timestamp	5	timestamp with time zone	NO
povlist_mirror	id	1	integer	NO	nextval(('"povlist_mirror_id_seq"'::text)::regclass)
povlist_mirror	pov	2	integer	NO
povlist_mirror	title	3	character varying	NO
povlist_mirror	comment	4	text	NO
povlist_mirror	uid	5	text	NO
povlist_mirror	timestamp	6	timestamp with time zone	YES	('now'::text)::timestamp without time zone
povlist_mirror	netabare	7	boolean	YES
povlist_mirror_edit_log	id	1	integer	NO	nextval(('"povlist_mirror_edit_log_id_seq"'::text)::regclass)
povlist_mirror_edit_log	pov	2	integer	NO
povlist_mirror_edit_log	title	3	character varying	NO
povlist_mirror_edit_log	comment	4	text	NO
povlist_mirror_edit_log	uid	5	text	NO
povlist_mirror_edit_log	timestamp	6	timestamp with time zone	NO
povlist_mirror_edit_log	netabare	7	boolean	NO
povmygroup	uid	1	text	NO
povmygroup	pov	2	integer	NO
povmygroup	adoption	3	boolean	YES
povnodegroups	id	1	integer	NO	nextval(('"povnodegroups_id_seq"'::text)::regclass)
povnodegroups	pov	2	integer	NO
povnodegroups	pov_parent_node	3	integer	NO
povnodegroups	touhyou	4	integer	NO	1
povnodelist	id	1	integer	NO	nextval(('"povnodelist_id_seq"'::text)::regclass)
povnodelist	title	2	character varying	NO
povnodelist	uid	3	text	NO
povnodelist	timestamp	4	timestamp with time zone	YES	('now'::text)::timestamp without time zone
recommendation_okazu_middle_table	game_1	1	integer	NO
recommendation_okazu_middle_table	okazu_tokuten_1	2	integer	NO
recommendation_okazu_middle_table	game_2	3	integer	NO
recommendation_okazu_middle_table	okazu_tokuten_2	4	integer	NO
recommendation_okazu_middle_table	count_2	5	integer	NO
resemble_user	uid	1	text	NO
resemble_user	resemble_uid	2	text	NO
resemble_user	point	3	double precision	NO
resemble_user	count	4	integer	NO
reviewpagelist	id	1	integer	NO	nextval(('"reviewpagelist2_id_seq"'::text)::regclass)
reviewpagelist	game	2	integer	NO
reviewpagelist	reviewpage	3	integer	NO
reviewpagelist	tokuten	4	integer	YES
reviewpagelist	tourokubi	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone
reviewpagelist	memo	6	text	YES
reviewpagelist	link	7	text	YES
reviewpagelist	checked	8	boolean	YES	true
rireki	game	1	integer	NO
rireki	datetime	2	timestamp with time zone	NO
rireki	count	3	integer	NO
rireki	count_old	4	integer	YES
rireki	avg	5	integer	NO
rireki	avg_old	6	integer	YES
rirekitable	koushinbi	1	date	NO
rirekitable	game	2	integer	NO
rirekitable	median	3	integer	YES
rirekitable	median2	4	integer	YES
rirekitable	average	5	integer	YES
rirekitable	average2	6	integer	YES
rirekitable	count	7	integer	YES
rirekitable	count2	8	integer	YES
serch_word	category	1	text	YES
serch_word	word	2	text	YES
serch_word	media	3	text	YES
serch_word	timestamp	4	timestamp without time zone	NO	now()
serch_word_his	category	1	text	YES
serch_word_his	word	2	text	YES
serch_word_his	media	3	text	YES
serch_word_his	timestamp	4	timestamp without time zone	NO
shokushu	id	1	integer	NO	nextval(('"shokushu_id_seq"'::text)::regclass)
shokushu	game	2	integer	NO
shokushu	creater	3	integer	NO
shokushu	shubetu	4	integer	NO
shokushu	checked	5	boolean	YES	false
shokushu	note	6	text	YES
shokushu	shubetu_detail	7	integer	YES
shokushu	shubetu_detail_name	8	text	YES
shokushu	ip	9	text	YES
shokushu	timestamp	10	timestamp without time zone	YES	now()
shokushu	sort_num	11	integer	YES
shokushu_backup	id	1	integer	YES
shokushu_backup	game	2	integer	NO
shokushu_backup	creater	3	integer	NO
shokushu_backup	shubetu	4	integer	NO
shokushu_backup	checked	5	boolean	YES
shokushu_backup	note	6	text	YES
shokushu_backup	shubetu_detail	7	integer	YES
shokushu_backup	shubetu_detail_name	8	text	YES
shokushu_backup	ip	9	text	YES
shokushu_backup	create_at	10	timestamp without time zone	YES	now()
singer	music	1	integer	NO
singer	creater	2	integer	NO
singer	name	3	text	NO	''::text
singer	featuring	4	boolean	NO	false
singer	created_at	5	timestamp without time zone	NO	now()
singer	updated_at	6	timestamp without time zone	NO	now()
sql_cost	cost	1	double precision	NO
sql_cost	sql	2	text	NO
sql_cost	timestamp	3	timestamp with time zone	YES	('now'::text)::timestamp without time zone
stage	id	1	integer	NO	nextval('stage_id_seq'::regclass)
stage	game	2	integer	NO
stage	stage	3	integer	NO
stage	name	4	text	NO
stage	explanation	5	text	NO	''::text
stage	ip	6	text	NO
stage	created_at	7	timestamp without time zone	NO	now()
stage	updated_at	8	timestamp without time zone	NO	now()
stage	order_number	9	integer	NO	100
storelist	id	1	integer	NO	nextval('storelist_id_seq'::regclass)
storelist	name	2	text	NO
storelist	url	3	text	NO
storelist	affid	4	text	YES
storelist	memo	5	text	YES
storelist	timestamp	6	timestamp without time zone	NO	now()
storelist	initial	7	text	YES
support_platform	uid	1	text	NO
support_platform	game	2	integer	NO
support_platform	platform	3	integer	NO
support_platform	operation	4	integer	NO
support_platform	memo	5	text	YES
support_platform	timestamp	6	timestamp without time zone	NO	now()
taglist	name	1	text	NO
taglist	furigana	2	text	NO	'未設定'::text
taglist	timestamp	3	timestamp without time zone	NO	now()
taglist	netabare	4	boolean	NO	false
tmp	game	1	integer	NO
tmp	tokuten	2	integer	NO
tmp	host	3	text	NO
toukei_temp_table	gamename	1	text	NO
toukei_temp_table	brandname	2	text	NO
toukei_temp_table	sellday	3	date	YES
toukei_temp_table	median	4	integer	YES
toukei_temp_table	average	5	real	YES
toukei_temp_table	stddev	6	integer	YES
toukei_temp_table	count	7	integer	YES
toukei_temp_table	allcount	8	integer	YES
toukei_temp_table	game_id	9	integer	NO
toukei_temp_table	brand_id	10	integer	NO
toukei_temp_table	coterie	11	integer	YES
toukei_temp_table	erogame	12	boolean	YES
toukei_temp_table	model	13	text	YES
toukei_temp_table	boyslove	14	integer	YES
twitter_timestamp_for_api	timestamp	1	timestamp without time zone	YES	('now'::text)::timestamp without time zone
user_dislike_user	dislike_uid	1	text	NO
user_dislike_user	voter_uid	2	text	NO
user_dislike_user	timestamp	3	timestamp without time zone	YES	now()
user_game_preferences	uid	1	text	NO
user_game_preferences	group_id	2	integer	NO
user_game_preferences	category_id	3	integer	NO
user_game_preferences	game	4	integer	NO
user_game_preferences	display_type	5	text	NO	'image'::text
user_game_preferences	display_source	6	text	NO	'fanza'::text
user_game_preferences	display_text	7	text	NO	''::text
user_rss_articles	id	1	integer	NO	nextval('user_rss_articles_id_seq'::regclass)
user_rss_articles	feed_id	2	integer	YES
user_rss_articles	title	3	text	NO
user_rss_articles	link	4	text	NO
user_rss_articles	pub_date	5	timestamp without time zone	YES
user_rss_articles	created_at	6	timestamp without time zone	NO	CURRENT_TIMESTAMP
user_rss_feeds	id	1	integer	NO	nextval('user_rss_feeds_id_seq'::regclass)
user_rss_feeds	uid	2	text	YES
user_rss_feeds	name	3	text	NO
user_rss_feeds	url	4	text	NO
user_rss_feeds	rss_url	5	text	NO	''::text
user_rss_feeds	created_at	6	timestamp without time zone	NO	CURRENT_TIMESTAMP
user_user	uid	1	text	NO
user_user	voter_uid	2	text	NO
user_user	timestamp	3	timestamp without time zone	YES	now()
user_user_game_recommended	id	1	integer	NO	nextval('user_user_game_recommended_id_seq'::regclass)
user_user_game_recommended	uid	2	text	NO
user_user_game_recommended	game	3	integer	NO
user_user_game_recommended	recommender_uid	4	text	NO
user_user_game_recommended	comment	5	text	NO
user_user_game_recommended	timestamp	6	timestamp without time zone	NO	now()
user_user_game_recommended	update_timestamp	7	timestamp without time zone	NO	now()
user_user_game_recommended	checked	8	boolean	NO	false
user_user_game_recommended_response	id	1	integer	NO	nextval('user_user_game_recommended_response_id_seq'::regclass)
user_user_game_recommended_response	user_user_game_recommended_id	2	integer	NO
user_user_game_recommended_response	response_uid	3	text	NO
user_user_game_recommended_response	comment	4	text	NO
user_user_game_recommended_response	timestamp	5	timestamp without time zone	NO	now()
usercreater	uid	1	text	NO
usercreater	creater	2	integer	NO
usercreater	comment	3	text	YES
usercreater	rank	4	integer	NO	5
usercreater	timestamp	5	timestamp without time zone	YES	now()
usermusic_comment	music	1	integer	NO
usermusic_comment	uid	2	text	NO
usermusic_comment	comment	3	text	NO
usermusic_comment	created_at	4	timestamp without time zone	NO	now()
usermusic_comment	updated_at	5	timestamp without time zone	NO	now()
usermusic_tokuten	music	1	integer	NO
usermusic_tokuten	uid	2	text	NO
usermusic_tokuten	tokuten	3	integer	NO
usermusic_tokuten	created_at	4	timestamp without time zone	NO	now()
usermusic_tokuten	updated_at	5	timestamp without time zone	NO	now()
userreview	game	1	integer	NO
userreview	uid	2	text	NO
userreview	tokuten	3	integer	YES
userreview	tourokubi	4	timestamp with time zone	YES
userreview	hitokoto	5	character varying	YES
userreview	memo	6	text	YES
userreview	netabare	7	boolean	YES	true
userreview	id	8	integer	NO	nextval(('userreviewid'::text)::regclass)
userreview	giveup	9	boolean	YES	false
userreview	possession	10	boolean	YES	false
userreview	play	11	boolean	YES	false
userreview	reserve	12	boolean	YES	false
userreview	outline	13	text	YES
userreview	before_hitokoto	14	text	YES
userreview	before_tokuten	15	integer	YES
userreview	before_tourokubi	16	timestamp without time zone	YES
userreview	outline_hitokoto	17	character varying	YES
userreview	display	18	boolean	YES	false
userreview	play_tourokubi	19	timestamp without time zone	YES
userreview	outline_netabare	20	boolean	YES	false
userreview	outline_tourokubi	21	timestamp without time zone	YES
userreview	display_unique_count	22	integer	YES
userreview	sage	23	boolean	YES	false
userreview	before_purchase_will	24	text	YES
userreview	before_sage	25	boolean	YES	false
userreview	total_play_time	26	integer	YES
userreview	time_before_understanding_fun	27	integer	YES
userreview	okazu_tokuten	28	integer	YES	'-999'::integer
userreview	trial_version_hitokoto	29	text	YES
userreview	trial_version_hitokoto_sage	30	boolean	YES	false
userreview	trial_version_hitokoto_tourokubi	31	timestamp without time zone	YES
userreview	timestamp	32	timestamp without time zone	YES	now()
userreview	modified	33	timestamp without time zone	YES	now()
userreview	review_private	34	boolean	NO	false
userreview_display_daily_log	id	1	integer	NO	nextval('userreview_display_daily_log_id_seq'::regclass)
userreview_display_daily_log	game	2	integer	NO
userreview_display_daily_log	uid	3	text	NO
userreview_display_daily_log	date	4	date	NO
userreview_display_daily_log	count	5	integer	NO
userreview_display_log	id	1	integer	NO	nextval('userreview_display_log_id_seq'::regclass)
userreview_display_log	game	2	integer	NO
userreview_display_log	uid	3	text	NO
userreview_display_log	ip	4	text	NO
userreview_display_log	agent	5	text	YES
userreview_display_log	referer	6	text	YES
userreview_display_log	timestamp	7	timestamp without time zone	NO	('now'::text)::timestamp(6) without time zone
userreview_netabare	game	1	integer	NO
userreview_netabare	uid	2	text	NO
userreview_netabare	voter_uid	3	text	NO
userreview_netabare	yes_no	4	boolean	NO
userreview_netabare	timestamp	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone
userreview_netabare	reason	6	text	YES
userreview_response	id	1	integer	NO	nextval(('"userreview_response_id_seq"'::text)::regclass)
userreview_response	game	2	integer	NO
userreview_response	uid	3	text	NO
userreview_response	timestamp	4	timestamp with time zone	NO
userreview_response	comment	5	text	NO
userreview_response	response_uid	6	text	NO
userreview_response	sage	7	boolean	YES	false
userreview_tag	uid	1	text	NO
userreview_tag	game	2	integer	NO
userreview_tag	tags	3	text	NO
userreview_tag	timestamp	4	timestamp without time zone	NO	now()
userreview_touhyou	game	1	integer	NO
userreview_touhyou	uid	2	text	NO
userreview_touhyou	voter_uid	3	text	NO
userreview_touhyou	hitokoto	4	text	YES
userreview_touhyou	timestamp	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone
userreview_touhyou	sage	6	boolean	YES	false
userreview_toukei_table	uid	1	text	NO
userreview_toukei_table	tokuten_avg	2	integer	YES
userreview_toukei_table	tokuten_stddev	3	integer	YES
userreview_toukei_table	tokuten_count	4	integer	YES
userreview_toukei_table	tourokubi_max	5	timestamp with time zone	YES
userreview_toukei_table	tourokubi_min	6	timestamp with time zone	YES
userreview_toukei_table	hitokoto_count	7	integer	YES
userreview_toukei_table	memo_count	8	integer	YES
userreview_toukei_table	before_hitokoto_count	9	integer	YES
userreview_toukei_table	before_tokuten_avg	10	integer	YES
userreview_toukei_table	before_tokuten_stddev	11	integer	YES
userreview_toukei_table	before_tokuten_count	12	integer	YES
userreview_toukei_table	trial_hitokoto_count	13	integer	YES
userreview_trial_netabare	game	1	integer	NO
userreview_trial_netabare	uid	2	text	NO
userreview_trial_netabare	voter_uid	3	text	NO
userreview_trial_netabare	yes_no	4	boolean	NO
userreview_trial_netabare	timestamp	5	timestamp without time zone	NO	'2010-11-06 18:18:46.66991'::timestamp without time zone
userreview_with_tag	tag	1	text	NO
userreview_with_tag	uid	2	text	NO
userreview_with_tag	game	3	integer	NO
userreview_with_tag	comment	4	text	YES
userreview_with_tag	timestamp	5	timestamp without time zone	NO	now()
usersql	id	1	integer	NO	nextval(('"usersql_id_seq"'::text)::regclass)
usersql	uid	2	text	NO
usersql	sql	3	text	NO
usersql	title	4	text	NO
usersql	explanation	5	text	YES
usersql	create_timestamp	6	timestamp with time zone	YES	('now'::text)::timestamp without time zone
usersql	update_timestamp	7	timestamp with time zone	YES	('now'::text)::timestamp without time zone
usersql	public_open	8	boolean	NO	false
usersql_touhyou	id	1	integer	NO
usersql_touhyou	uid	2	text	NO
usersql_touhyou	hitokoto	3	text	YES
usersql_touhyou	rank	4	integer	NO	10
usersql_touhyou	timestamp	5	timestamp with time zone	YES	('now'::text)::timestamp without time zone

実行したSQL

      SELECT table_name, column_name, ordinal_position, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_name in (SELECT table_name FROM information_schema.tables
                     WHERE table_schema='public' AND table_type='BASE TABLE')
ORDER BY table_name, ordinal_position