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)