상품
테이블 (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_NOTICE (Untitled5)
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