-- Table: public.users

-- DROP TABLE public.users;

CREATE TABLE public.users
(
    username character varying(20) COLLATE pg_catalog."default" NOT NULL,
    u_password character varying(20) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT users_pkey PRIMARY KEY (username)
)

TABLESPACE pg_default;

ALTER TABLE public.users
    OWNER to postgres;

////////////////////////////////////////////////////
-- Table: public.member

-- DROP TABLE public.member;

CREATE TABLE public.member
(
    memberid character(20) COLLATE pg_catalog."default" NOT NULL,
    membername character(20) COLLATE pg_catalog."default" NOT NULL,
    memberphone character(20) COLLATE pg_catalog."default",
    CONSTRAINT member_pkey PRIMARY KEY (memberid)
)

TABLESPACE pg_default;

ALTER TABLE public.member
    OWNER to postgres;

////////////////////////////////////////////////
-- Table: public.commodity

-- DROP TABLE public.commodity;

CREATE TABLE public.commodity
(
    comid character(20) COLLATE pg_catalog."default" NOT NULL,
    comname character(20) COLLATE pg_catalog."default",
    comprice integer,
    CONSTRAINT commodity_pkey PRIMARY KEY (comid)
)

TABLESPACE pg_default;

ALTER TABLE public.commodity
    OWNER to postgres;

//////////////////////////////////////////////////
-- Table: public.pet

-- DROP TABLE public.pet;

CREATE TABLE public.pet
(
    petid character(20) COLLATE pg_catalog."default" NOT NULL,
    petname character(20) COLLATE pg_catalog."default" NOT NULL,
    petvar character(20) COLLATE pg_catalog."default",
    petage integer,
    petmemid character(20) COLLATE pg_catalog."default",
    petremark character(20) COLLATE pg_catalog."default",
    CONSTRAINT pet_pkey PRIMARY KEY (petid),
    CONSTRAINT pet_petmemid_fkey FOREIGN KEY (petmemid)
)

TABLESPACE pg_default;

ALTER TABLE public.pet
    OWNER to postgres;


///////////////////////////////////////////////////////////
-- Table: public.spend

-- DROP TABLE public.spend;

CREATE TABLE public.spend
(
    specomid character(20) COLLATE pg_catalog."default" NOT NULL,
    spepetid character(20) COLLATE pg_catalog."default" NOT NULL,
    spenum integer,
    speunit integer,
    spetotal integer,
    CONSTRAINT spend_pkey PRIMARY KEY (specomid, spepetid),
    CONSTRAINT spend_specomid_fkey FOREIGN KEY (specomid)
    CONSTRAINT spend_spepetid_fkey FOREIGN KEY (spepetid)
)

TABLESPACE pg_default;

ALTER TABLE public.spend
    OWNER to postgres;