﻿drop table household.household;
create table household.household(
	idx SERIAL PRIMARY KEY,
	householddate date,
	moneytype char(1),
	contents varchar(255),
	money decimal(20,0),
	other varchar(255),
	creater varchar(100),
	createdate date,
	state char(1),
	householdtype int,
	category bigint
);
drop table household.connectLog;
create table household.connectLog(
	idx SERIAL PRIMARY KEY,
	userid varchar(255),
	conntecttime timestamp
);
drop table household.category;
create table household.category(
	idx SERIAL PRIMARY KEY,
	householdtype int,
	moneytype char(1),
	categoryname varchar(255),
	creater varchar(255),
	createdate date,
	state char(1)
);
drop table household.session;
create table household.session(
	userid varchar(255) primary key,
	sessionKey varchar(100)
);
drop table household.usertable;
create table household.usertable(
	userid varchar(255) primary key,
	userpw varchar(100),
	username varchar(255),
	householdtype int
)