JHC_ERD

테이블 (7)

공통 (Untitled)

  • createdAt — Date
  • updatedAt — Date
  • reg_date — String
  • update_date — String
  • del_it — String

유저 (member)

  • idx — int — 기본 키 — NOT NULL
  • user_id — varchar(30)
  • user_pw — varchar(200)
  • user_name — varchar(50)
  • user_email — varchar(50)
  • user_phone — varchar(50)
  • department — varchar(50)
  • position — varchar(50)

입고이력 (income_history)

  • id — String — 기본 키 — NOT NULL
  • product_name — String
  • product_category — String
  • serial — String
  • income_date — Date
  • manager — String

재고 (inventory)

  • id — String — 기본 키 — NOT NULL
  • order_id — String — 외래 키 → 주문이력.id — NOT NULL
  • product_code — String
  • product_name — String
  • product_category — String
  • serial — String
  • income_date_first — Date
  • income_date_re — Date
  • release_date_first — Date
  • release_date_re — Date
  • release_location — String
  • inventory_state — String

주문메모 (order_memo)

  • id — int — 기본 키 — NOT NULL
  • order_id — varchar(20) — 외래 키 → 주문이력.id — NOT NULL
  • name — varchar(50)
  • content (conetnt) — varchar(1000)
  • reg_date (regdate) — datetime
  • update_date — datetime

주문이력 (order_history)

  • id — String — 기본 키 — NOT NULL
  • order_date — DateTime
  • product_name — String
  • product_category — String
  • order_name — String
  • order_tel — String
  • bill_it — String
  • qa — int
  • price — int
  • tax — int
  • manager — String
  • serial — String
  • delivery_company — String
  • delivery_invoice — String
  • delivery_date — Date
  • delivery_address — String
  • delivery_name — String
  • delivery_tel — String
  • payment_date — Date
  • payment_way — String
  • payment_state — String
  • payment_person — String
  • delivery_state — String
  • del_it — String

출고이력 (release_history)

  • id — String — 기본 키 — NOT NULL
  • product_name — String
  • product_category — String
  • serial — String
  • manager — String
  • release_location — String
  • release_date — Date