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