M_CYOUSA

-- Table: public."M_CYOUSA"


-- DROP TABLE public."M_CYOUSA";


CREATE TABLE public."M_CYOUSA"
(
    "CODE" character(5) COLLATE pg_catalog."default" NOT NULL,
    "SYUBETSU" integer NOT NULL,
    "CYOUSA_KU" integer NOT NULL,
    "GYO" integer NOT NULL,
    "OL_ID" character(9) COLLATE pg_catalog."default" NOT NULL,
    "PRT_NUM" integer NOT NULL DEFAULT 0,
    "PRT_AT" timestamp with time zone,
    "PASSWORD" character varying(32) COLLATE pg_catalog."default",
    "TMP_FLG" integer NOT NULL DEFAULT 0,
    "LAST_ID" character(9) COLLATE pg_catalog."default",
    "MEMO" character varying(100) COLLATE pg_catalog."default",
    CONSTRAINT "M_CYOUSA_pkey" PRIMARY KEY ("CODE", "SYUBETSU", "CYOUSA_KU", "GYO")
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;


ALTER TABLE public."M_CYOUSA"
    OWNER to postgres;