sdds
Tables (22)
admin (wsdd_admin)
- admin_id — varchar(32) — Primary key — NOT NULL
- login_pw — varchar(265)
- name — varchar(32)
- tel1 — varchar(32)
- tel2 — varchar(32)
- mobile — varchar(32)
- email — varchar(255)
- title — varchar(32)
- company_code — varchar(32)
- remote_ip — varchar(16)
- use_yn — bool
- send_yn — bpchar(1)
- last_conn_dt — bpchar(14)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
- token — varchar(200)
- auto_login — bpchar(1)
admin_org (wsdd_admin_org)
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- admin_id — varchar(32) — Foreign key → admin.admin_id — NOT NULL
- reg_dt — bpchar(14)
- tel1 — varchar(32)
- tel2 — varchar(32)
admin_role (wsdd_admin_role)
- admin_id — varchar(32) — Foreign key → admin.admin_id — NOT NULL
- role_id — varchar(20) — Foreign key → role.role_id — NOT NULL
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
agent_patch (wsdd_agent_patch)
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- setup_ver — varchar(20)
- setup_date — varchar(32)
- upgrade_ver — varchar(32)
- upgrade_date — varchar(14)
code (wsdd_code)
- code_id — varchar(20) — Primary key — NOT NULL
- code_value — varchar(50) — Primary key — NOT NULL
- code_nm — varchar(255)
- code_nm_en — varchar(255)
- use_yn — varchar(4)
- bundle_yn — varchar(4)
- disp_ordr — numeric(10)
- pcode_id — varchar(20)
- pcode_value — varchar(255)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
config (wsdd_config)
- config_key — varchar(255) — Primary key — NOT NULL
- seq — int4 — Primary key — NOT NULL
- config_value — varchar(255)
- config_comment — varchar(255)
device (wsdd_device)
- device_id — varchar(32) — Primary key — NOT NULL
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- device_key — varchar(32)
- hdd_serial — varchar(64)
- mac_address — varchar(16)
- ip_address1 — varchar(64)
- ip_address2 — varchar(64)
- agent_ver — varchar(256)
- user_id — varchar(20)
- os — varchar(256)
- hostname — varchar(256)
- last_conn_dt — bpchar(14)
- valid_status — varchar(4)
- cert_status — varchar(4)
- cert_dt — bpchar(14)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
license (wsdd_license)
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- license — varchar(256)
- type — varchar(4)
- agents — int4
- exp_dt — varchar(14)
- status — varchar(4)
- reg_dt — varchar(14)
- upd_dt — varchar(14)
menu (wsdd_menu)
- menu_type — varchar(4) — Primary key — NOT NULL
- menu_id — varchar(4) — Primary key — NOT NULL
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- img_uuid — varchar(32)
- sub_type — varchar(4)
- menu_name — varchar(255)
- menu_desc — varchar(255)
- price — varchar(255)
- disp_ordr — varchar(4)
- is_show — varchar(4)
- reg_dt — bpchar(14)
- handler — bpchar(14)
- is_sold — varchar(4)
- is_best — varchar(4)
menu_opts_group (wsdd_menu_opts_group)
- opts_group_id — varchar(16) — Primary key — NOT NULL
- menu_type — varchar(4) — Foreign key → menu.menu_type — NOT NULL
- menu_id — varchar(4) — Foreign key → menu.menu_id — NOT NULL
- org_id — varchar(20) — Foreign key → menu.org_id — NOT NULL
- opts_group_name — varchar(255)
- opts_group_type — varchar(4)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
menu_opts_group_items (wsdd_menu_opts_group_items)
- opts_id — varchar(16) — Primary key — NOT NULL
- opts_group_id — varchar(16) — Foreign key → menu_opts_group.opts_group_id — NOT NULL
- menu_type — varchar(4) — Foreign key → menu_opts_group.menu_type — NOT NULL
- menu_id — varchar(4) — Foreign key → menu_opts_group.menu_id — NOT NULL
- org_id — varchar(20) — Foreign key → menu_opts_group.org_id — NOT NULL
- opts_name — varchar(255)
- opts_price — varchar(255)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
menu_top (wsdd_menu_top)
- menu_id — varchar(4) — Foreign key → menu.menu_id — NOT NULL
- org_id — varchar(20) — Foreign key → menu.org_id — NOT NULL
- menu_name — varchar(255)
- disp_ordr — varchar(4)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
- menu_type — varchar(4)
notice (wsdd_notice)
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- contents — text
order_cart (wsdd_order_cart)
- table_num — varchar(4) — Foreign key → table_info.table_num — NOT NULL
- org_id — varchar(20) — Foreign key → table_info.org_id — NOT NULL
- req_type — varchar(4)
- req — varchar(4)
- cnt — varchar(4)
- is_request — varchar(4)
- opts — text
- opts_id — varchar(4)
order_cnt (wsdd_order_cnt)
- org_id — varchar(20) — Foreign key → table_info.org_id — NOT NULL
- order_date — bpchar(8)
- order_id — varchar(8)
order_req (wsdd_order_req)
- table_num — varchar(4) — Foreign key → order_cart.table_num — NOT NULL
- org_id — varchar(20) — Foreign key → order_cart.org_id — NOT NULL
- order_id — varchar(8)
- order_date — bpchar(8)
- order_time — bpchar(8)
order_res (wsdd_order_res)
- table_num — varchar(4) — Foreign key → order_req.table_num — NOT NULL
- org_id — varchar(20) — Foreign key → order_req.org_id — NOT NULL
- req_type — varchar(4)
- req — varchar(4)
- cnt — varchar(4)
- order_date — bpchar(8)
- order_time — bpchar(6)
- opts — text
- opts_id — varchar(4)
org (wsdd_org)
- org_id — varchar(20) — Primary key — NOT NULL
- org_name — varchar(256)
- org_fullnm — varchar(256)
- org_fullcd — varchar(256)
- org_pid — varchar(256)
- org_depth — int4
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
- disp_ordr — int4
- org_type — varchar(4)
- is_geo — varchar(4)
- geo_lat — varchar(32)
- geo_lon — varchar(32)
- geo_range — varchar(8)
- open_time — varchar(8)
- close_time — varchar(8)
- first_cost — varchar(8)
- is_open — varchar(4)
role (wsdd_role)
- role_id — varchar(20) — Primary key — NOT NULL
- role_name — varchar(256)
- role_desc — varchar(256)
- role_type — varchar(4)
- system_role — bpchar(1)
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
role_func (wsdd_role_func)
- role_id — varchar(20) — Foreign key → role.role_id — NOT NULL
- func_id — varchar(20) — Foreign key → wsdd_func.func_id — NOT NULL
- reg_dt — bpchar(14)
- upd_dt — bpchar(14)
table_info (wsdd_table_info)
- table_num — varchar(4) — Primary key — NOT NULL
- org_id — varchar(20) — Foreign key → org.org_id — NOT NULL
- is_locked — varchar(2)
- table_pw — varchar(255)
- is_availabled — varchar(4)
- qrcode — varchar(128)
- qr_dt — bpchar(14)
- nickname — varchar(4)
wsdd_func
- func_id — varchar(20) — Primary key — NOT NULL
- func_name — varchar(256)
- func_desc — varchar(256)
- use_yn — varchar(4)
- p_func_id — varchar(20)
- func_type — varchar(4)
- component_id — varchar(255)
- icon — varchar(255)
- tooltip — varchar(255)
- handler — varchar(255)
- disp_ordr — int4