リスト4　goods.ddl

CREATE TABLE "goods" (
        "id" BIGINT NOT NULL,
        "sample" VARCHAR(128),
        "detailCategoryCategory_id" BIGINT NOT NULL,
        "detailCategoryCategory_name" VARCHAR(128) NOT NULL,
        "detailPricePrice_id" BIGINT NOT NULL,
        "detailPricePrice_cost" BIGINT NOT NULL,
        "detailPricePrice_retail" BIGINT NOT NULL,
        "name" VARCHAR(128) NOT NULL,
        "xmlDate" DATE,
        "description" VARCHAR(128)
)