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
- 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