test1
Tables (13)
audit_log_2000
- log_id — VARCHAR(255) — NOT NULL
- entity_id — VARCHAR(255) — NOT NULL
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — varchar(1)
authority_menu_3000
- authority_id — long — NOT NULL
- menu_id — VARCHAR(255) — NOT NULL
- access_type — VARCHAR(255)
- access_level — VARCHAR(255)
- remark — VARCHAR(255)
- use_yn — VARCHAR(1)
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — varchar(1)
bookmark_2000
- account_id — long — NOT NULL
- seq_no — long — NOT NULL
- approver_id — long — NOT NULL
- approver_type — VARCHAR(255) — NOT NULL
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — varchar(1) — NOT NULL
chat_nt_3000
- chat_id — long — NOT NULL
- sender_id — long — NOT NULL
- receiver_id — long — NOT NULL
- msg — varchar(1000) — NOT NULL
complain_2000
- complain_id — long — NOT NULL
- complain_category_id — long — NOT NULL
- complain_user_no — long — NOT NULL
- account_id — long — NOT NULL
- complain_status — VARCHAR(255) — NOT NULL
- rcpt_dt — VARCHAR(255)
- proc_dt — VARCHAR(255)
- approval_proc_dt — VARCHAR(255)
- due_dt — DATE — NOT NULL
- reason — VARCHAR(255)
- del_yn — VARCHAR(1)
complain_user_2000
- complain_user_no — long — NOT NULL
- complain_user_name — VARCHAR2(50) — NOT NULL
- complain_user_residentnumber — VARCHAR2(50) — NOT NULL
- complain_user_phonenumber — VARCHAR2(50) — NOT NULL
- complain_user_email — VARCHAR2(50) — NOT NULL
- complain_user_address — VARCHAR2(100) — NOT NULL
- complain_user_address_detail — VARCHAR(255)
- complain_user_cd — VARCHAR(255)
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — VARCHAR(1)
department_nt_1000
- dept_id — long — NOT NULL
- dept_name — varchar2(255) — NOT NULL
- dept_enable — varchar(1) — NOT NULL
- dept_phone — VARCHAR2(50) — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
- del_yn — varchar(1) — NOT NULL
institution_department
- inst_id — long — NOT NULL
- dept_id — long — NOT NULL
institution_mt_1000
- inst_id — long — NOT NULL
- inst_name — varchar2(255) — NOT NULL — 기관명
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
- inst_address — varchar2(255) — NOT NULL
- inst_phone — VARCHAR2(50) — NOT NULL
- inst_type — varchar2(255) — NOT NULL
- inst_code — varchar2(255) — NOT NULL
manager_assignment
- account_id — long — NOT NULL
- dept_id — long — NOT NULL
- complain_category_id — long — NOT NULL
- inst_id — long — NOT NULL
- assigned_date — DATE — NOT NULL
menu_3000
- menu_id — VARCHAR(255) — NOT NULL
- menu_name — VARCHAR(255)
- menu_url — VARCHAR(255)
- parent_menu_id — VARCHAR(255)
- seq — VARCHAR(255)
- menu_desc — VARCHAR(255)
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — varchar(1)
notice_3000
- notice_id — VARCHAR(255) — NOT NULL
- account_id — long — NOT NULL
- title — VARCHAR(255)
- content — VARCHAR(2000)
- start_dt — DATE
- end_dt — DATE
- priority — VARCHAR(255)
- created_at — DATE
- updated_at — DATE
proxy_2000
- abs_id — long — NOT NULL
- delegate_id — long — NOT NULL
- seq_no — long — NOT NULL
- start_dt — DATE — NOT NULL
- end_dt — DATE — NOT NULL
- comment — varchar(255)
- created_at — DATE
- updated_at — DATE
- created_id — long
- updated_id — long
- del_yn — varchar(1) — NOT NULL