just using merge space
Tables (17)
1member (MEMBER)
- UserNumber — NUMBER — Primary key — NOT NULL
- name — varchar2
- email — varchar2
- password — varchar2
- role — VARCHAR2
ATTATCHMENT
- FILE_NO — NUMBER — Primary key — NOT NULL
- ESTIMATE_ID — NUMBER — Foreign key → Estimate.ESTIMATE_ID — NOT NULL
- ORIGIN__NAME — VARCHAR2
- CHANGE_NAME — VARCHAR2
- FILE_PATH — VARCHAR2
- UPLOAD_DATE — DATE
- FILE_LEVEL — NUMBER
- STATUS — VARCHAR2
AuctionStatus
- AUCTION_ID — NUMBER — Primary key — NOT NULL
- ESTIMATE_ID — NUMBER — Foreign key → Estimate.ESTIMATE_ID — NOT NULL
- CURRENT_PRICE — NUMBER
- BID_COUNT — NUMBER
- LAAST_BID_AT — DATE
- STATUS — VARCHAR2
BidHistory
- BIDHISTORY_ID — NUMBER — Primary key — NOT NULL
- MASTER_ID — NUMBER — NOT NULL
- SERVICE_ID — NUMBER — Foreign key → Service.SERVICE_ID — NOT NULL
- ESTIMATE_ID — NUMBER — Foreign key → Estimate.ESTIMATE_ID — NOT NULL
- PRICE — NUMBER
- STATUS — VARCHAR2
- CREATED_AT — DATE
- REGION_ID — NUMBER — Foreign key → Estimate.REGION_ID — NOT NULL
CHECKIN_LOG
- log_id — NUMBER — Primary key — NOT NULL — 로그식별자
- worker_id — NUMBER — Foreign key → 1member.UserNumber — NOT NULL — 워커식별자
- reader_id — NUMBER — Foreign key → RFID_READER.reader_id — NOT NULL — 리더기식별자
- timestamp — DATE — 타임스탬프
- action_type — VARCAHR2 — 태깅타입
- status — VARCHAR2 — 상태
- Field — VARCHAR(255) — 경고
- Field2 — VARCHAR(255)
ESTIMATED_BID
- PRIORITY_ID — NUMBER — Primary key — NOT NULL
- MASTER_ID — NUMBER — NOT NULL
- ESTIMATE_ID — NUMBER — Foreign key → Estimate.ESTIMATE_ID — NOT NULL
- PRICE — NUMBER
- Field — VARCHAR2
- STATUS — VARCHAR2
- CREATED_AT — DATE
Estimate
- ESTIMATE_ID — NUMBER — Primary key — NOT NULL
- USER_ID — NUMBER — NOT NULL
- SERVICE_ID — NUMBER — Foreign key → Service.SERVICE_ID — NOT NULL
- REGION_ID — NUMBER — Foreign key → REGION.REGION_ID — NOT NULL
- TITLE — VARCHAR2
- DESCRIPTION — VARCHAR2
- REQUEST_DATE — DATE
- STATUS — VARCHAR2
- CREATED_AT — DATE
- UPDATED_AT — DATE
PARTNER_COMPANY
- company_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2
- address — VARCHAR2
- contact_email — VARCHAR2
- contract_start — DATE
- contract_end — DATE
PRIORITY
- PRIORITY_ID — NUMBER — Primary key — NOT NULL
- ESTIMATE_ID — NUMBER — Foreign key → Estimate.ESTIMATE_ID — NOT NULL
- PRIORITY_TYPE — VARCHAR2
- WEIGHT — NUMBER
REGION
- REGION_ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR2 — 지역
- Field — VARCHAR(255)
RFID_READER
- reader_id — NUMBER — Primary key — NOT NULL — 리더기식별자
- location — VARCHAR2 — 리더기설치장소
- device_identifier — VARCHAR2 — 리더기UID
- worksite_id — NUMBER — Foreign key → WORKSITE.worksite_id — NOT NULL
RFID_TAG
- rfid_tag_id — NUMBER — Primary key — NOT NULL — RFID카드식별자
- uid — VARCHAR(255)
- issued_to_worker — NUMBER — Foreign key → 1member.UserNumber — NOT NULL
- issued_at — DATE
- is_active — VARCHAR(255)
Service
- SERVICE_ID — NUMBER — Primary key — NOT NULL
- MAIN_CATEGORY — NUMBER
- SERVICE_NAME — VARCHAR2
- DESCRIPTION — VARCHAR2 — 향후
- Field — VARCHAR(255)
TASK
- task_id — NUMBER — Primary key — NOT NULL — 작업식별자
- session_id — NUMBER — Foreign key → WORK_SESSION.session_id — NOT NULL — 세션식별자
- task_type — VARCAHR2 — 작업유형
- description — VARCAHR2 — 설명
- started_at — DATE — 작업시작시간
- completed_at — DATE — 작업종료시간
- task_status — VARCHAR2 — 작업상태
- Field — VARCHAR(255) — 작업유형은
- Field2 — VARCHAR(255)
WORKER_PROFILE
- worker_id — NUMBER — Foreign key → 1member.UserNumber — NOT NULL
- is_certificated — VARCHAR2 — 인증여부
- certificated_at — DATE
- rfid_tag_id — NUMBER — Foreign key → RFID_TAG.rfid_tag_id — NOT NULL — RFID카드식별자
- available — VARCHAR2
WORKSITE
- worksite_id — NUMBER — Primary key — NOT NULL
- company_id — NUMBER — Foreign key → PARTNER_COMPANY.company_id — NOT NULL
- location_detail — VARCHAR2
- Field — VARCHAR(255) — 범주
WORK_SESSION
- session_id — NUMBER — Primary key — NOT NULL — 세션식별자
- worker_id — NUMBER — Foreign key → 1member.UserNumber — NOT NULL
- worksite_id — NUMBER — Foreign key → WORKSITE.worksite_id — NOT NULL
- started_at — DATE — 업무시작시간
- ended_at — DATE — 업무종료시간
- status — VARCHAR2 — 업무상태
- Field — VARCHAR(255) — 업무
- Field2 — VARCHAR(255)