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)