asap
Tables (8)
chat_members (talk_members)
- id — Primary key — NOT NULL
- chat_room_id (Field) — bigint(20)
- member_id (Field2) — bigint(20)
- status (Field3) — varchar(10)
- created_dt (Field4) — datetime
- updated_dt (Field5) — datetime
chat_rooms (talk)
- id — Primary key — NOT NULL
- subject (Field) — varchar(18)
- notice (Field8) — varchar(36)
- member_id (Field2) — bigint(20)
- created_dt (Field3) — datetime
- updated_dt (Field4) — datetime
- delete_yn (Field5) — bit(1)
- join_cnt (Field6) — int(11)
- last_msg_dt (Field7) — datetime
- category (Field9) — varchar(20)
coupon (Untitled)
- code (1) — TEXT
- name (2) — TEXT
- endDate (3) — TEXT
- publisher (4) — TEXT
- imageUrl (5) — TEXT
extra
- templateParams (-) — JSON
- - (orderNo) — -
- attachments (Field) — JSON
- - (imageUrl) — TEXT
- - (imageHashId) — TEXT
- - (buttons) — LIST
- - (1) — TEXT
- - (2) — TEXT
- - (3) — TEXT
- - (4) — TEXT
- - (5) — TEXT
- - (gift) — JSON
- - (/) — JSON
file
- id — Primary key — NOT NULL
- origin_name (Field) — varchar(256)
- new_name (Field2) — varchar(256)
- path (Field3) — varchar(256)
- ext (Field4) — varchar(10)
member (Untitled2)
- id — Primary key — NOT NULL
- user_id (Field) — varchar(12)
- user_pw (Field2) — varchar(16)
- user_name (Field3) — varchar(10)
- email (Field4) — varchar(256)
- role (Field7) — varchar(10)
- created_dt (Field5) — datetime
- updated_dt (Field6) — datetime
messages
- id — Primary key — NOT NULL
- content (Field) — varchar(2000)
- member_id (Field2) — bigint(20)
- chat_room_id (Field3) — bigint(20)
- created_dt (Field4) — datetime
- updated_dt (Field5) — datetime
- type (Field6) — varchar(10)
- file_id (Field7) — bigint(20)
msg_group_sub
- id — bigint
- gid — varchar(64) — NOT NULL
- uid — varchar(50)
- sender_key — varchar(40)
- template_code — varchar(64)
- response_method — varchar(8)
- re_type — varchar(3)
- re_body — text
- ad_flag — char
- attached_file — varchar(2000)
- img_url — varchar(2000)
- created_dt — datetime
- chatbot_id — varchar(40)
- header — varchar(1)
- footer — varchar(64)
- copy_allowed — varchar(1)
- rcs_body — varchar(4000)
- agency_key — varchar(64)
- brand_key — varchar(64)
- buttons — varchar(4000)
- messagebase_id — varchar(40)
- partnerid — varchar(40)
- partnerkey — varchar(64)
- msgtype — varchar(2)
- username — varchar(5)
- groupkey — varchar(30)
- extra — varchar(4000)