상품

테이블 (8)

TB_ADMIN (Untitled4)

  • ADMIN_NO (PK) — INTEGER — 기본 키 — NOT NULL
  • ADMIN_ID (Field) — VARCHAR
  • ADMIN_NAME (Field2) — VARCHAR
  • ADMIN_POSITION (Field3) — VARCHAR
  • ADMIN_PW (Field4) — VARCHAR

TB_BOARD_FNQ (Untitled7)

    TB_BOARD_NOTICE (Untitled5)

      TB_BOARD_QNA (Untitled6)

        TB_CATEGORY (Untitled3)

        • CATEGORY_GOODS_PARENT_NO (FK1) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_GOODS_SUB_NO (FK2) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_GOODS_NO (PK) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_GOODS_NAME (Field) — VARCHAR
        • CATEGORY_GOODS_NAME_SUB (Field2) — VARCHAR
        • CATEGORY_GOODS_UNIT (Field3) — VARCHAR
        • CATEGORY_GOODS_WEIGHT (Field4) — VARCHAR
        • CATEGORY_GOODS_FROM (Field5) — VARCHAR
        • CATEGORY_GOODS_PACKAGING_TYPE (Field6) — VARCHAR
        • CATEGORY_GOODS_DELIVERY_TYPE (Field7) — VARCHAR
        • CATEGORY_GOODS_EXP_DATE (Field8) — VARCHAR
        • CATEGORY_GOODS_INFO (Field9) — VARCHAR
        • CATEGORY_GOODS_REF (Field10) — VARCHAR
        • CATEGORY_GOODS_CONTENTS_TIT_MAIN (Field11) — VARCHAR
        • CATEGORY_GOODS_CONTENTS_TIT_SUB (Field12) — VARCHAR
        • CATEGORY_GOODS_CONTENTS_INTRO (Field13) — VARCHAR
        • CATEGORY_GOODS_IMAGE_THUMB (Field14) — VARCHAR
        • CATEGORY_GOODS_IMAGE_HEAD (Field15) — VARCHAR
        • CATEGORY_GOODS_IMAGE_CONTENTS (Field16) — VARCHAR
        • CATEGORY_GOODS_IMAGE_CONTENTS_DETAIL (Field17) — VARCHAR
        • Field18

        TB_CATEGORY_PARENT (Untitled)

        • CATEGORY_PARENT_NO (PK) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_PARENT_NAME (FK) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_PARENT_ICON (Field) — VARCHAR
        • CATEGORY_PARENT_ICON_COLOR (Field2) — VARCHAR

        TB_CATEGORY_SUB (Untitled2)

        • CATEGORY_SUB_NO (PK) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_SUB_NAME (FK) — VARCHAR — 기본 키 — NOT NULL
        • CATEGORY_SUB_PARENT_NO (Field) — VARCHAR

        Untitled8