withgo

Tables (16)

DriverList (기사)

  • id — uuid — Primary key — NOT NULL
  • driver_id — text
  • name — text
  • phone — text
  • email — text
  • address — text
  • memo — text
  • photo_url — text
  • file_url — text
  • created_at — timestamp
  • birthday — text
  • gender — text
  • password — text

Users (고객)

  • UID — Primary key — NOT NULL
  • Display name
  • Email
  • Phone
  • Providers
  • Provider type
  • Created at
  • Last sign in at

alerts (알림)

  • id — uuid — Primary key — NOT NULL
  • dl_id — uuid — Foreign key → deliveryList.dl_id — NOT NULL
  • status — character
  • created_at — timestamp — NOT NULL
  • update_at — timestamp

delivery (배송)

  • re_num — uuid — Primary key — NOT NULL
  • user_id — Foreign key → Users.UID — NOT NULL
  • name — text — NOT NULL
  • phone — text — NOT NULL
  • delivery_date — date — NOT NULL
  • delivery_start — text — NOT NULL
  • delivery_arrive — text — NOT NULL
  • price — integer — NOT NULL
  • reserve_time — timestamp
  • detail_adr — text
  • under — integer — NOT NULL
  • over — integer — NOT NULL
  • situation — text
  • success_time — timestamp
  • status_updated_at — timestamp

deliveryList (배송예약)

  • dl_id — uuid — Primary key — NOT NULL
  • driver_id — uuid — Foreign key → DriverList.id — NOT NULL
  • re_num — uuid — Foreign key → delivery.re_num — NOT NULL
  • s_time — timestamp
  • f_time — timestamp
  • customer_name — text
  • customer_phone — text
  • driver_name — text
  • driver_phone — text
  • delivery_date — date
  • delivery_start — text
  • delivery_arrive — text
  • under — integer
  • over — integer
  • price — numeric
  • status — text
  • photo_url — text

employees (관리자)

  • no — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • email — character — NOT NULL
  • department — character
  • position — character
  • role — character
  • status — character
  • created_at — timestamp
  • memo — text
  • password — text

partner_place (제휴숙소)

  • partner_id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • address — character — NOT NULL
  • phone — character
  • map_url — text
  • image — text
  • created_at — timestamp

question (1:1문의)

  • text_num — integer — Primary key — NOT NULL
  • user_id — Foreign key → Users.UID — NOT NULL
  • title — text — NOT NULL
  • name — text — NOT NULL
  • pw — text — NOT NULL
  • question_txt — text — NOT NULL
  • secret — boolean
  • views — integer
  • stat — text — NOT NULL
  • created_at — timestamp
  • type — text — NOT NULL
  • image_url — text
  • answer — text

review (후기)

  • review_num — integer — Primary key — NOT NULL
  • user_id — Foreign key → Users.UID — NOT NULL
  • name — text — NOT NULL
  • title — text — NOT NULL
  • password — character — NOT NULL
  • created_at — timestamp
  • review_txt — text — NOT NULL
  • file_url — text
  • type — text
  • is_best — boolean
  • status — text

status_logs

  • id — bigint — Primary key — NOT NULL
  • key_value (key_value_s) — Foreign key → storage.user_id — NOT NULL
  • key_value (key_value_d) — uuid — Foreign key → delivery.re_num — NOT NULL
  • table_name — text — NOT NULL
  • prev_status — text
  • new_status — text — NOT NULL
  • updated_at — timestamp — NOT NULL
  • received_at — timestamp
  • operator — text

storage (보관)

  • reservation_number — uuid — Primary key — NOT NULL
  • user_id — Foreign key → Users.UID — NOT NULL
  • name — character — NOT NULL
  • phone — character — NOT NULL
  • storage_start_date — date — NOT NULL
  • storage_end_date — date — NOT NULL
  • location — character — NOT NULL
  • mail — character
  • small — integer
  • medium — integer
  • large — integer
  • price — numeric
  • reservation_time — timestamp
  • situation — text
  • success_time — timestamp
  • status_updated_at — timestamp

storage_place (보관장소)

  • storage_id — integer — Primary key — NOT NULL
  • name — character — NOT NULL
  • address — character — NOT NULL
  • phone — character
  • map_url — text
  • image — text
  • created_at — timestamp

subscription (푸시알림)

  • id — bigint — Primary key — NOT NULL
  • user_id — Foreign key → Users.UID — NOT NULL
  • subscription — jsonb — NOT NULL
  • created_at — timestamp

withgo_event (이벤트)

  • id — bigint — Primary key — NOT NULL
  • title — text — NOT NULL
  • date — date
  • img_url — text
  • link_url — text
  • status — text

withgo_faqs (FAQ)

  • id — bigint — Primary key — NOT NULL
  • question — text — NOT NULL
  • answer — text
  • created_at — timestamp
  • category — text
  • status — text

withgo_notifications (공지사항)

  • id — bigint — Primary key — NOT NULL
  • content — text
  • created_at — timestamp — NOT NULL
  • title — text
  • img_url — text