BBCAPI

Tables (8)

tb_api_code

  • code_type — varchar(30) — Primary key — NOT NULL
  • code — varchar(30) — Primary key — NOT NULL
  • code_nm — varchar(128) — NOT NULL
  • regist_dt — datetime — NOT NULL

tb_api_log

  • api_seq — double — Primary key — NOT NULL
  • api_content — text — NOT NULL
  • api_type — varchar(30)
  • api_target — varchar(30)
  • regist_dt — datetime — NOT NULL
  • api_url — varchar(256)
  • send_uri — varchar(256)
  • receive_url — varchar(256)

tb_member

  • user_id — varchar(128) — Primary key — NOT NULL
  • user_pwd — varchar(512) — NOT NULL
  • user_nm — varchar(128) — NOT NULL
  • user_group — varchar(30) — NOT NULL
  • user_role — varchar(30) — NOT NULL
  • regist_dt — datetime — NOT NULL
  • user_type — varchar(30)

tb_order_delay

  • delay_seq — int(11) — Primary key — NOT NULL
  • order_type — varchar(30) — NOT NULL
  • delay_time — int(11) — NOT NULL
  • regist_dt — datetime — NOT NULL

tb_order_hist

  • hist_seq — double — Primary key — NOT NULL
  • order_seq — double — Foreign key → tb_order_info.order_seq — NOT NULL
  • request_id — varchar(128) — Foreign key → tb_order_info.request_id — NOT NULL
  • status_cd — varchar(30) — NOT NULL
  • regist_dt — datetime — NOT NULL
  • hist_memo — varchar(100)

tb_order_info

  • order_seq — double — Primary key — NOT NULL
  • request_id — varchar(128) — Primary key — NOT NULL
  • order_type — varchar(30) — Primary key — NOT NULL
  • shop_cd — varchar(30) — Foreign key → tb_shop_info.shop_cd — NOT NULL
  • shop_nm — varchar(255)
  • user_nm_order — varchar(128)
  • user_tel_order — varchar(128)
  • user_nm_receiver — varchar(128)
  • user_tel_recevier — varchar(128)
  • dest_addr1 — varchar(255)
  • dest_addr2 — varchar(255)
  • dest_x — varchar(128)
  • dest_y — varchar(128)
  • paid_price — int(11)
  • total_price — int(11)
  • reserve_yn — varchar(1)
  • reserve_time — datetime
  • memo — varchar(512)
  • status_cd — varchar(30) — NOT NULL
  • order_dt — datetime
  • driver_nm — varchar(128)
  • driver_tel — varchar(128)
  • driver_cd — varchar(30)
  • delivery_dt — datetime
  • regist_dt — datetime — NOT NULL
  • trace_no — varchar(30)
  • delivery_id — varchar(60)
  • driver_assign_dt — datetime
  • request_dt — datetime
  • etc1 — varchar(100)
  • etc2 — varchar(100)
  • etc3 — varchar(100)
  • result_code — varchar(30)
  • result_msg — varchar(256)

tb_order_prod

  • prod_seq — int(11) — Primary key — NOT NULL
  • request_id — varchar(128) — Foreign key → tb_order_info.request_id — NOT NULL
  • order_type — varchar(30) — Foreign key → tb_order_info.order_type — NOT NULL
  • prod_nm — varchar(255) — NOT NULL
  • ea — int(11) — NOT NULL
  • price — int(11) — NOT NULL
  • regist_dt — datetime

tb_shop_info

  • order_type — varchar(30) — Primary key — NOT NULL
  • shop_cd — varchar(30) — Primary key — NOT NULL
  • shop_nm — varchar(256) — NOT NULL
  • shop_tel — varchar(30)
  • shop_mng_tel — varchar(30)
  • open_time — varchar(128)
  • order_time — varchar(128)
  • shop_addr1 — varchar(256)
  • shop_addr2 — varchar(256)
  • shop_x — varchar(128)
  • shop_y — varchar(128)
  • use_yn — varchar(1)
  • shop_si — varchar(30)
  • shop_gugun — varchar(30)
  • shop_dong — varchar(30)
  • area_cd — varchar(30)
  • etc1 — varchar(30)
  • etc2 — varchar(30)
  • etc3 — varchar(30)
  • deli_type — varchar(30)
  • regist_dt — datetime — NOT NULL