CURRENT_ERD
Tables (21)
CUS_TB
- CUS_PK — bigint
- CUS_NM — varchar(30) — NOT NULL
- CUS_ADR — varchar(30) — NOT NULL
FAC_ITEM_DETAIL_TB
- ITEM_DETAIL_SERIAL_NUM — bigint
- ITEM_STATE — smallint
- FAC_ITEM_PK — bigint — NOT NULL
FAC_ITEM_TB
- FAC_ITEM_PK — bigint
- FAC_ITEM_SELLER_NM — varchar(30)
- FAC_ITEM_CAT — varchar(30)
- FAC_ITEM_NM — varchar(30)
- FAC_ITEM_VOL — int
- FAC_ITEM_EXPIRATION_DT — date
- FAC_ITEM_PRICE — int
- FAC_ITEM_PROD_CNT — int
- Field — varchar(255)
FAC_TB
- FAC_PK — bigint
- FAC_NM — varchar(30) — NOT NULL
- LOC_PK — int — NOT NULL
GBG_DETAIL_TB
- GBG_DETAIL_PK — bigint
- ITEM_PK — bigint — NOT NULL — 화장품 개별이 아닌 화장품 묶음(재고)의 ID
- ITEM_STATE — smallint — NOT NULL
- GBG_SERIAL_NUM — varchar(30) — NOT NULL
INB_TB
- INB_PK — bigint
- SEL_PK — bigint — NOT NULL
- FAC_PK — bigint — NOT NULL
- WHS_PK — bigint — NOT NULL
- INB_ITEM_PK — bigint — NOT NULL
- INB_ITEM_CAT_PK — int — NOT NULL
- INB_ITEM_NM — varchar(30) — NOT NULL
- INB_ITEM_VOL — int — NOT NULL
- INB_ITEM_PRICE — int — NOT NULL
- INB_ITEM_CNT — int — NOT NULL
- INB_ITEM_EXPIRATION_DT — date — NOT NULL
ITEM_CAT_TB
- ITEM_CAT_PK — int
- ITEM_CAT_NM — varchar(30) — NOT NULL
ITEM_DETAIL_TB
- ITEM_DETAIL_SERIAL_NUM — varchar(30) — Primary key — NOT NULL
- ITEM_DETAIL_PK — bigint
- ITEM_PK — bigint — NOT NULL
- ITEM_DETAIL_STATUS — smallint — NOT NULL
- LOCATE_PK — bigint — NOT NULL
- ITEM_DETAIL_EXPIRATION_DT — date — NOT NULL
ITEM_TB
- ITEM_PK — bigint
- ITEM_NM — varchar(30) — NOT NULL
- ITEM_VOL — int — NOT NULL
- ITEM_CAT_PK — int — NOT NULL
- ITEM_CNT — int
LOCATE_TB
- LOCATE_PK — bigint
- LOCATE_ITEM_CNT — int — 수용량 최대
- LOCATE_LPN_CODE — varchar(30) — NOT NULL
- WHS_PK — bigint — NOT NULL
LOC_TB
- LOC_PK — int
- LOC_NM — varchar(30) — NOT NULL
OUTB_DETAIL_TB
- OUTB_DETAIL_PK — bigint
- OUTB_FK — bigint — NOT NULL
- ITEM_NM — varchar(30) — NOT NULL
- OUTB_PICKING_CNT — int — NOT NULL — 픽킹해야할 수량
OUTB_TB
- OUTB_PK — bigint
- CUS_FK — bigint — NOT NULL
- ORDER_DT — date — NOT NULL
OUT_CART_TB
- OUT_CART_PK — bigint
- OUTB_DETAIL_FK — bigint — NOT NULL
- OUTB_CART_CNT — smallint — NOT NULL — LIMIT 50
OUT_ITEM_DETAIL_TB
- OUT_ITEM_DETAIL_PK — bigint
- ITEM_STATE — smallint — NOT NULL
- ITEM_PK — bigint — NOT NULL
- ITEM_EXPIRATION_DT — date — NOT NULL
- ITEM_DETAIL_SERIAL_NUM — varchar(30)
- OUT_CART_PK — bigint — NOT NULL
SEL_ORDER_DETAIL_TB
- SEL_ORDER_DETAIL_PK — bigint
- SEL_ORDER_FK — bigint — NOT NULL
- SEL_ORDER_PROD_NM — varchar(30) — NOT NULL
- SEL_ORDER_DETAIL_VOL — int — NOT NULL
- SEL_ORDER_DETAIL_CNT — int — NOT NULL
SEL_ORDER_TB
- SEL_ORDER_PK — bigint
- SEL_ORDER_DATE_DT — date — NOT NULL
- CUS_PK — bigint — NOT NULL
- SEL_ORDER_STATUS — smallint
SEL_TB
- SEL_PK — bigint
- SEL_NM — varchar(30) — NOT NULL
- SEL_ADR — varchar(30) — NOT NULL
- LOC_PK — int — NOT NULL
WHS_ADMIN_TB
- WHS_ADMIN_PK — bigint
- WHS_EMAIL — varchar(30) — NOT NULL
- WHS_PW — varchar(30) — NOT NULL
- WHS_NM — varchar(30) — NOT NULL
- WHS_PK — bigint — NOT NULL
WHS_TB
- WHS_PK — bigint
- WHS_NM — varchar(30) — NOT NULL
- LOC_PK — int — NOT NULL
- WHS_CAPACITY — bigint — NOT NULL