truck-matching- customer

Tables (4)

auction_apply (경매 신청 정보테이블)

  • auction_id (Key) — bigint — Primary key — NOT NULL
  • pickup_id (Key2) — bigint — Foreign key → pickup.pickup_id — NOT NULL
  • truck_id (FK2) — bigint — Foreign key → truck_owner.truck_id — NOT NULL
  • money (Field) — bigint
  • Field3

pickup (픽업 및 배달 완료 정보)

  • pickup_id (Key) — bigint — Primary key — NOT NULL
  • user_id (FK1) — bigint — Foreign key → user.user_id — NOT NULL
  • truck_id (FK2) — bigint — Foreign key → truck_owner.truck_id — NOT NULL
  • auction_id (Field) — bigint
  • pickup_address1 (Field1) — varchar2(30)
  • pickup_address2 (Field2) — varchar2(30) — 강남구, 동작구, 마포구 등의 구
  • pickup_address3 (Field3) — varchar2(30)
  • pickup_address4 (Field4) — varchar2(30)
  • delivery_address1 (Field5) — varchar2(30) — 서울특별시 경기도 부산광역시 인천광역시등
  • delivery_address2 (Field6) — varchar2(30)
  • delivery_address3 (Field7) — varchar2(30)
  • delivery_address4 (Field8) — varchar2(30)
  • progress_level (Field9) — varchar2(50)
  • delivery_kind (Field10) — varchar2(50)
  • pickup_date (Field11) — date
  • delivery_complete_date (Field12) — date
  • create_date (Field134) — date
  • update_date (Field154) — date

truck_owner (트럭기사 정보)

  • truck_id (PK) — bigint — Primary key — NOT NULL
  • id (Field) — varchar2(30)
  • password (Field2) — varchar2(100)
  • name (Field3) — varchar2(30)
  • profile_url (Field4) — varchar2(250)
  • phone1 (Field5) — varchar2(3)
  • phone2 (Field6) — varchar2(4)
  • phone3 (Field7) — varchar2(4)
  • grade (Field8) — varchar2(30)
  • pickup_favorite_address1 (Field9) — varchar2(30)
  • pickup_favorite_address2 (Field10) — varchar2(30)
  • favorite_address3 (Field11) — varchar2(30)
  • delivery_favorite_address1 (Field12) — varchar2(30)
  • delivery_favorite_address2 (Field13) — varchar2(30)
  • delivery_favorite_address3 (Field14) — varchar2(30)
  • Field15
  • Field16

user

  • user_id (PK) — bigint — Primary key — NOT NULL
  • oauth_id (Field) — varchar2(100)
  • name (Field2) — varchar2(25)
  • address1 (Field3) — varchar2(30)
  • address2 (Field4) — varchar2(30)
  • address3 (Field5) — varchar2(30)
  • address4 (Field6) — varchar2(100)
  • post_address (Field7) — varchar2(10)
  • phone1 (Field8) — varchar2(3)
  • phone2 (Field9) — varchar2(4)
  • phone3 (Field10) — varchar2(4)
  • grade (Field11) — varchar2(30)
  • final_login_date (Field12) — date
  • oauth_provider (Field13) — varchar2(50)
  • fire_base_id (Field14) — varchar2(100)
  • create_date (Field15) — date
  • update_date (Field16) — date