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

INVOICE_TB

  • INVOICE_NUM — bigint

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