Storage

Tables (12)

bom

  • id — BIGINT — Primary key — NOT NULL — sequence number (bom_id)
  • version — VARCHAR(10) — BoM 버전
  • title — VARCHAR(50) — BoM title

bom_part_list

  • id — BIGINT — Primary key — NOT NULL — sequence number (bom_part_list_id)
  • bom_id — BIGINT — Foreign key → bom.id — NOT NULL — sequence number (bom_id)
  • part_id — BIGINT — Foreign key → part.id — NOT NULL — sequence number (part_id)
  • quantity — INT — 부품 수량

magazine_info

  • id — INT — Primary key — NOT NULL — sequence number
  • storage_id — INT — Foreign key → storage.id — NOT NULL — sequence number (storage_id)
  • magazine — INT — 층
  • reel_type — CHAR(1) — Foreign key → reel_type.reel_type — NOT NULL — reel 종류
  • reel_max_cnt — INT — reel 최대 저장 가능 개수

part

  • id — BIGINT — Primary key — NOT NULL — 부품 번호 (내부 관리 번호)
  • part_code — VARCHAR(50) — 부품 설명
  • description — VARCHAR(100) — sequence number (part_mapping_id)

part_mapping

  • id — BIGINT — Primary key — NOT NULL — 제조사
  • part_id — BIGINT — Foreign key → part.id — 제조사 부품 번호
  • manufacturer — VARCHAR(50) — NOT NULL — sequence number (reel_id)
  • mfr_part_code — VARCHAR(50) — NOT NULL — sequence number

reel

  • id — BIGINT — Primary key — NOT NULL — 제조사
  • part_mapping_id — BIGINT — Foreign key → part_mapping.id — NOT NULL — 제조일
  • manufacturer — VARCHAR(50) — 제조사의 reel id
  • manufacture_date — DATE — 총수량(입고기준)
  • mfr_reel_id — VARCHAR(30) — reel 종류
  • total_qty — INT — NOT NULL — 크기
  • reel_type — CHAR(1) — Foreign key → reel_type.reel_type — NOT NULL — 두께
  • diameter — VARCHAR(20) — NOT NULL — 상태 (L:Load, U:Unload, E:Expired)
  • width — VARCHAR(20) — NOT NULL — storage_location id
  • action_status — CHAR(1) — NOT NULL — 남은수량
  • location_id — BIGINT — 유효기간
  • remaining_qty — INT — NOT NULL — sequence number
  • expiry_date — DATE — NOT NULL — reel id

reel_transaction

  • id — BIGINT — Primary key — NOT NULL — L: Load(입고), U: Unload(출고)
  • reel_id — BIGINT — Foreign key → reel.id — NOT NULL — 작업자
  • action_type — CHAR(1) — 입출고 시간
  • user_id — INT — Foreign key → users.id — NOT NULL — 입출고 위치
  • action_date — DATE — memo
  • location_id — BIGINT — Foreign key → storage_location.id — NOT NULL — reel 종류
  • memo — BLOB — 크기

reel_type

  • reel_type — CHAR(1) — Primary key — NOT NULL — 두께
  • diameter — VARCHAR(20) — sequence number (storage_id)
  • width — VARCHAR(20) — storage name

storage

  • id — INT — Primary key — NOT NULL — IP Address
  • name — VARCHAR(30) — model name
  • IP — VARCHAR(20) — sequence number (location_id)
  • model_NM — VARCHAR(10) — Foreign key → storage_model.model_NM — NOT NULL — sequence number (storage_id)

storage_location

  • id — BIGINT — Primary key — NOT NULL — 층
  • storage_id — INT — Foreign key → storage.id — NOT NULL — 층에서의 위치
  • magazine — CHAR(1) — 층에서의 위치 (각도)
  • idx — INT — sequence number (reel_id)
  • position — INT — A: available, O:Occupied
  • reel_id — BIGINT — Foreign key → reel.id — R:Reserved(예약), T: Tentative(임시예약), F: Free
  • status — CHAR(1) — 작업자
  • reserv_flag — CHAR(1) — model name
  • user_id — INT — Foreign key → users.id — 전체 층수

storage_model

  • model_NM — VARCHAR(10) — Primary key — NOT NULL — version
  • magazines — CHAR(1) — 층별 구성 (top-> down)
  • version — CHAR(1) — sequence number (user_id)
  • reel_types — VARCHAR(6) — user id

users

  • id — INT — NOT NULL — user password
  • user — VARCHAR(20) — NOT NULL — 이름
  • password — VARCHAR(100) — NOT NULL — 역할
  • name — VARCHAR(50)