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)