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