API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
590
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 67.27 KB | None | 0 0
raw download clone embed print report
  1. Database: 371894_IC
  2. Table: YP_RESPONSES
  3. [7 columns]
  4. +---------------+---------------+
  5. | Column | Type |
  6. +---------------+---------------+
  7. | COMMENTS | varchar(1000) |
  8. | CREATED_DT | date |
  9. | EMAIL | text |
  10. | NAME | varchar(50) |
  11. | PHONE | varchar(12) |
  12. | SNO | int(5) |
  13. | YP_LISTING_ID | int(6) |
  14. +---------------+---------------+
  15.  
  16. Database: 371894_IC
  17. Table: IC_HEALTH_CITIES
  18. [3 columns]
  19. +-----------+--------------+
  20. | Column | Type |
  21. +-----------+--------------+
  22. | CITY_ID | int(11) |
  23. | CITY_NM | varchar(100) |
  24. | FOLDER_NM | varchar(100) |
  25. +-----------+--------------+
  26.  
  27. Database: 371894_IC
  28. Table: IC_GLOBAL_WD_LISTING
  29. [17 columns]
  30. +---------------------+---------------+
  31. | Column | Type |
  32. +---------------------+---------------+
  33. | COUNT | int(11) |
  34. | COMPANY_DESCR | varchar(4000) |
  35. | COMPANY_LOGO_FILE | varchar(100) |
  36. | COMPANY_NAME | varchar(100) |
  37. | COMPANY_WEB_URL | varchar(100) |
  38. | CONTACT_INFO_URL | varchar(150) |
  39. | CREATED_BY_USERID | varchar(15) |
  40. | CREATED_DT | date |
  41. | LAST_UPDATED_DT | date |
  42. | LAST_UPDATED_USERID | varchar(15) |
  43. | PARENT_CAT_ID | int(4) |
  44. | STOCK_CODE | varchar(30) |
  45. | STOCK_EXCHANGE | varchar(30) |
  46. | SUB_CAT_ID | int(4) |
  47. | TOLLFREE_NBR | varchar(20) |
  48. | UID | varchar(25) |
  49. | WD_LISTING_ID | int(6) |
  50. +---------------------+---------------+
  51.  
  52. Database: 371894_IC
  53. Table: YP_DIRECTORY_TEMP
  54. [3 columns]
  55. +----------+--------------+
  56. | Column | Type |
  57. +----------+--------------+
  58. | DIR_CODE | int(11) |
  59. | DIR_ID | int(11) |
  60. | DIR_NAME | varchar(255) |
  61. +----------+--------------+
  62.  
  63. Database: 371894_IC
  64. Table: GWD_RESPONSES
  65. [10 columns]
  66. +-----------------+---------------+
  67. | Column | Type |
  68. +-----------------+---------------+
  69. | COMMENTS | varchar(5000) |
  70. | CREATED_DT | date |
  71. | EMAIL | varchar(100) |
  72. | GWD_LISTING_ID | int(10) |
  73. | NAME | varchar(50) |
  74. | PHONE | varchar(1000) |
  75. | REPLY_MESSAGE | varchar(2000) |
  76. | REPLYED_BY_NAME | varchar(50) |
  77. | REPLYED_DATE | date |
  78. | SNO | int(10) |
  79. +-----------------+---------------+
  80.  
  81. Database: 371894_IC
  82. Table: NRI_RESPONSES
  83. [7 columns]
  84. +----------------+---------------+
  85. | Column | Type |
  86. +----------------+---------------+
  87. | COMMENTS | varchar(1000) |
  88. | CREATED_DT | date |
  89. | EMAIL | text |
  90. | NAME | varchar(50) |
  91. | NRI_LISTING_ID | int(6) |
  92. | PHONE | varchar(12) |
  93. | SNO | int(5) |
  94. +----------------+---------------+
  95.  
  96. Database: 371894_IC
  97. Table: IC_WD_PREMIUM_LISTINGS
  98. [22 columns]
  99. +--------------------+---------------+
  100. | Column | Type |
  101. +--------------------+---------------+
  102. | CATEGORY_ID | smallint(6) |
  103. | COMMENTS | varchar(1000) |
  104. | CONTACT_EMAIL | varchar(100) |
  105. | CONTACT_NAME | varchar(100) |
  106. | CONTACT_PHONE | varchar(50) |
  107. | CREATE_DT | datetime |
  108. | CREATED_BY | varchar(20) |
  109. | CURRENCY_CD | varchar(5) |
  110. | DESCRIPTION | varchar(1000) |
  111. | END_DT | date |
  112. | LAST_UPDATED_BY | varchar(20) |
  113. | LAST_UPDATED_DT | datetime |
  114. | ORDER_ID | int(11) |
  115. | PAYMENT_AMT | int(11) |
  116. | PAYMENT_DETAILS | varchar(1000) |
  117. | PAYMENT_DT | date |
  118. | PAYPAL_TXN_ID | varchar(50) |
  119. | PREMIUM_LISTING_ID | smallint(6) |
  120. | REFERRED_BY | varchar(50) |
  121. | START_DT | date |
  122. | TITLE | varchar(100) |
  123. | WEBSITE_URL | varchar(200) |
  124. +--------------------+---------------+
  125.  
  126. Database: 371894_IC
  127. Table: IC_GLOBAL_WD_SUB_CAT
  128. [10 columns]
  129. +---------------------+---------------+
  130. | Column | Type |
  131. +---------------------+---------------+
  132. | CREATED_BY_USERID | varchar(15) |
  133. | CREATED_DT | date |
  134. | LAST_UPDATED_DT | date |
  135. | LAST_UPDATED_USERID | varchar(15) |
  136. | PARENT_CAT_ID | int(6) |
  137. | SUB_CAT_DESCR | varchar(1000) |
  138. | SUB_CAT_FILE_NAME | varchar(100) |
  139. | SUB_CAT_ID | int(6) |
  140. | SUB_CAT_IMAGE_FILE | varchar(100) |
  141. | SUB_CAT_NAME | varchar(50) |
  142. +---------------------+---------------+
  143.  
  144. Database: 371894_IC
  145. Table: IC_RE_CATEGORIES
  146. [3 columns]
  147. +---------+-------------+
  148. | Column | Type |
  149. +---------+-------------+
  150. | CAT_ID | smallint(6) |
  151. | CAT_NM | varchar(50) |
  152. | FILE_NM | varchar(50) |
  153. +---------+-------------+
  154.  
  155. Database: 371894_IC
  156. Table: IC_TELL_A_FRIEND
  157. [8 columns]
  158. +---------------+--------------+
  159. | Column | Type |
  160. +---------------+--------------+
  161. | COMMENTS | varchar(500) |
  162. | NAME | varchar(50) |
  163. | REC_EMAIL1 | varchar(50) |
  164. | REC_EMAIL2 | varchar(50) |
  165. | REC_EMAIL3 | varchar(50) |
  166. | SNO | int(6) |
  167. | USER_EMAIL | varchar(50) |
  168. | WD_LISTING_ID | int(6) |
  169. +---------------+--------------+
  170.  
  171. Database: 371894_IC
  172. Table: YP_DIRECTORY
  173. [3 columns]
  174. +----------+--------------+
  175. | Column | Type |
  176. +----------+--------------+
  177. | DIR_CODE | int(11) |
  178. | DIR_ID | int(11) |
  179. | DIR_NAME | varchar(255) |
  180. +----------+--------------+
  181.  
  182. Database: 371894_IC
  183. Table: IC_HEALTH_CATEGORIES
  184. [3 columns]
  185. +-----------+--------------+
  186. | Column | Type |
  187. +-----------+--------------+
  188. | CAT_ID | int(11) |
  189. | CAT_NM | varchar(100) |
  190. | FILE_NAME | varchar(100) |
  191. +-----------+--------------+
  192.  
  193. Database: 371894_IC
  194. Table: BUSINESS_EXECS_BK
  195. [10 columns]
  196. +----------------------+--------------+
  197. | Column | Type |
  198. +----------------------+--------------+
  199. | BUS_PROFILE_ID | int(11) |
  200. | CREATED_BY_USER | varchar(20) |
  201. | CREATED_DT | date |
  202. | EXECUTIVE_DISGNATION | varchar(100) |
  203. | EXECUTIVE_EMAIL | varchar(100) |
  204. | EXECUTIVE_NAME | varchar(50) |
  205. | EXECUTIVE_PHONE | varchar(100) |
  206. | EXECUTIVE_SEQ_NUM | int(4) |
  207. | LAST_UPDATED_DT | date |
  208. | LT_UP_BY_USER | varchar(20) |
  209. +----------------------+--------------+
  210.  
  211. Database: 371894_IC
  212. Table: IC_APP_USER
  213. [12 columns]
  214. +---------------------+--------------+
  215. | Column | Type |
  216. +---------------------+--------------+
  217. | CREATED_BY_USERID | varchar(15) |
  218. | CREATED_DT | date |
  219. | EID | int(5) |
  220. | EMAIL | varchar(100) |
  221. | LAST_UPDATED_DT | date |
  222. | LAST_UPDATED_USERID | varchar(15) |
  223. | PASSWORD | varchar(15) |
  224. | STATUS | varchar(50) |
  225. | SUPER_USER | varchar(10) |
  226. | USER_FIRST_NAME | varchar(25) |
  227. | USER_LAST_NAME | varchar(25) |
  228. | USERID | varchar(12) |
  229. +---------------------+--------------+
  230.  
  231. Database: 371894_IC
  232. Table: NRI_USERS
  233. [10 columns]
  234. +---------------------+-------------+
  235. | Column | Type |
  236. +---------------------+-------------+
  237. | CREATED_BY_USERID | varchar(25) |
  238. | CREATED_DT | date |
  239. | ID | int(3) |
  240. | LAST_UPDATED_DT | date |
  241. | LAST_UPDATED_USERID | varchar(25) |
  242. | PASSWORD | varchar(25) |
  243. | SUPER_USER | varchar(25) |
  244. | USER_FIRST_NAME | varchar(25) |
  245. | USER_LAST_NAME | varchar(25) |
  246. | USERID | varchar(25) |
  247. +---------------------+-------------+
  248.  
  249. Database: 371894_IC
  250. Table: INTERESTED_SERVICES
  251. [7 columns]
  252. +-------------------+------------+
  253. | Column | Type |
  254. +-------------------+------------+
  255. | BUS_PROFILE_ID | int(11) |
  256. | COMP_SYS_SUPPORT | varchar(1) |
  257. | CRM_SOLUTIONS | varchar(1) |
  258. | IT_TRAINING | varchar(1) |
  259. | OFFICE_AUTOMATION | varchar(1) |
  260. | ONLINE_MARKETING | varchar(1) |
  261. | WEB_SOLUTIONS | varchar(1) |
  262. +-------------------+------------+
  263.  
  264. Database: 371894_IC
  265. Table: PROFILE_COMMENTS
  266. [5 columns]
  267. +--------------+--------------+
  268. | Column | Type |
  269. +--------------+--------------+
  270. | COMMENTS | varchar(150) |
  271. | CONFIRM_CODE | varchar(16) |
  272. | NAME | varchar(50) |
  273. | POSTED_DATE | datetime |
  274. | PROFILE_ID | int(11) |
  275. +--------------+--------------+
  276.  
  277. Database: 371894_IC
  278. Table: INDUSTRY
  279. [4 columns]
  280. +--------------------+--------------+
  281. | Column | Type |
  282. +--------------------+--------------+
  283. | INDUSTRY_DESC | varchar(150) |
  284. | INDUSTRY_ID | int(4) |
  285. | PARENT_INDUSTRY_ID | int(4) |
  286. | PROFILE_DIRECTORY | varchar(50) |
  287. +--------------------+--------------+
  288.  
  289. Database: 371894_IC
  290. Table: WD_IMAGES
  291. [7 columns]
  292. +---------------+---------------+
  293. | Column | Type |
  294. +---------------+---------------+
  295. | CREATED_BY | varchar(50) |
  296. | CREATED_DATE | timestamp |
  297. | DESCRIPTION | varchar(3000) |
  298. | IMAGE_COUNT | int(11) |
  299. | IMAGE_NAME | varchar(20) |
  300. | SNO | int(11) |
  301. | WD_LISTING_ID | int(11) |
  302. +---------------+---------------+
  303.  
  304. Database: 371894_IC
  305. Table: IC_RE_CITIES
  306. [3 columns]
  307. +-----------+-------------+
  308. | Column | Type |
  309. +-----------+-------------+
  310. | CITY_ID | smallint(6) |
  311. | CITY_NM | varchar(50) |
  312. | FOLDER_NM | varchar(50) |
  313. +-----------+-------------+
  314.  
  315. Database: 371894_IC
  316. Table: COMMENTS
  317. [8 columns]
  318. +--------------+---------------+
  319. | Column | Type |
  320. +--------------+---------------+
  321. | APP_ID | int(11) |
  322. | CID | int(11) |
  323. | COMMENTS | varchar(1000) |
  324. | CONFIRM_CODE | varchar(32) |
  325. | LID | int(11) |
  326. | NAME | varchar(50) |
  327. | POSTED_DATE | date |
  328. | STATUS | varchar(1) |
  329. +--------------+---------------+
  330.  
  331. Database: 371894_IC
  332. Table: PG_LOGIN
  333. [4 columns]
  334. +------------+--------------+
  335. | Column | Type |
  336. +------------+--------------+
  337. | CREATED_DT | date |
  338. | LID | int(10) |
  339. | PASSWORD | varchar(32) |
  340. | UNAME | varchar(150) |
  341. +------------+--------------+
  342.  
  343. Database: 371894_IC
  344. Table: IC_IM_CATEGORY_MAP
  345. [3 columns]
  346. +------------------+--------------+
  347. | Column | Type |
  348. +------------------+--------------+
  349. | IC_CATEGORY | int(11) |
  350. | IC_CATEGORY_NAME | varchar(200) |
  351. | IM_CATEGORY_NAME | varchar(300) |
  352. +------------------+--------------+
  353.  
  354. Database: 371894_IC
  355. Table: IC_BUILDING_MATERIALS
  356. [15 columns]
  357. +--------------+--------------+
  358. | Column | Type |
  359. +--------------+--------------+
  360. | ADDR1 | varchar(100) |
  361. | ADDR2 | varchar(100) |
  362. | CATEGORY | varchar(100) |
  363. | CATEGORY_ID | smallint(6) |
  364. | CITY_ID | smallint(6) |
  365. | CITY_NM | varchar(50) |
  366. | COMPANY_NM | varchar(100) |
  367. | EMAIL | varchar(100) |
  368. | EXECUTIVE_NM | varchar(100) |
  369. | FAX | varchar(50) |
  370. | LISTING_ID | mediumint(9) |
  371. | MOBILE | varchar(50) |
  372. | PHONE | varchar(50) |
  373. | PINCODE | varchar(10) |
  374. | WEBSITE_URL | varchar(100) |
  375. +--------------+--------------+
  376.  
  377. Database: 371894_IC
  378. Table: INDIAMART_PROFILES_20_7
  379. [14 columns]
  380. +----------------------+---------------+
  381. | Column | Type |
  382. +----------------------+---------------+
  383. | ADDRESS | varchar(500) |
  384. | BUSINESS_DESC | varchar(2000) |
  385. | CATEGORY | varchar(500) |
  386. | CITY | varchar(100) |
  387. | COMPANY | varchar(200) |
  388. | COMPANY_ID | int(11) |
  389. | CONTACT_PERSON | varchar(200) |
  390. | COUNTRY | varchar(100) |
  391. | PHONE | varchar(100) |
  392. | PIN | varchar(100) |
  393. | PROMOTIONAL_EMAIL_ID | varchar(100) |
  394. | SNO | int(50) |
  395. | STATE | varchar(100) |
  396. | WEBSITE | varchar(200) |
  397. +----------------------+---------------+
  398.  
  399. Database: 371894_IC
  400. Table: PG_CATEGORIES
  401. [7 columns]
  402. +-----------------+-------------+
  403. | Column | Type |
  404. +-----------------+-------------+
  405. | CATEGORY_FOLDER | varchar(50) |
  406. | CATEGORY_ID | int(11) |
  407. | CATEGORY_NAME | varchar(50) |
  408. | CREATE_DT | timestamp |
  409. | CREATED_BY | varchar(20) |
  410. | LAST_UPDATED_BY | varchar(20) |
  411. | LAST_UPDATED_DT | date |
  412. +-----------------+-------------+
  413.  
  414. Database: 371894_IC
  415. Table: WEB_ADDRESS
  416. [15 columns]
  417. +-------------------+--------------+
  418. | Column | Type |
  419. +-------------------+--------------+
  420. | ADDRESS1 | varchar(200) |
  421. | ADDRESS2 | varchar(200) |
  422. | ADDRESS_TYPE | varchar(100) |
  423. | CITY | varchar(50) |
  424. | COUNTRY | varchar(100) |
  425. | CREATED_DT | timestamp |
  426. | EMAIL_ID | varchar(200) |
  427. | FAX | varchar(50) |
  428. | ID | int(11) |
  429. | LAST_UPDATED_DT | timestamp |
  430. | LAST_UPDATED_USER | varchar(100) |
  431. | PHONE | varchar(100) |
  432. | STATE | varchar(100) |
  433. | WID | int(11) |
  434. | ZIP | varchar(10) |
  435. +-------------------+--------------+
  436.  
  437. Database: 371894_IC
  438. Table: IC_IT_CITIES
  439. [3 columns]
  440. +-----------+-------------+
  441. | Column | Type |
  442. +-----------+-------------+
  443. | CITY_ID | smallint(6) |
  444. | CITY_NM | varchar(50) |
  445. | FOLDER_NM | varchar(50) |
  446. +-----------+-------------+
  447.  
  448. Database: 371894_IC
  449. Table: EMAIL_LOGIN
  450. [4 columns]
  451. +------------+--------------+
  452. | Column | Type |
  453. +------------+--------------+
  454. | CREATED_DT | date |
  455. | LID | int(10) |
  456. | PASSWORD | varchar(32) |
  457. | UNAME | varchar(150) |
  458. +------------+--------------+
  459.  
  460. Database: 371894_IC
  461. Table: CONTEXT
  462. [8 columns]
  463. +-------------------+-------------+
  464. | Column | Type |
  465. +-------------------+-------------+
  466. | CONTEXT_ID | varchar(3) |
  467. | LAST_UPDATE_DTTM | date |
  468. | LAST_UPDATE_OPRID | varchar(10) |
  469. | OPERATION | varchar(20) |
  470. | TABLENAME | varchar(30) |
  471. | TEMPLATE | varchar(32) |
  472. | TEMPLATE_CACHE | varchar(3) |
  473. | TEMPLATE_LOCATION | varchar(80) |
  474. +-------------------+-------------+
  475.  
  476. Database: 371894_IC
  477. Table: NRI_STATES
  478. [6 columns]
  479. +----------------+--------------+
  480. | Column | Type |
  481. +----------------+--------------+
  482. | LAST_PUBLISHED | date |
  483. | ROOT_URL | varchar(100) |
  484. | STATE_CD | varchar(5) |
  485. | STATE_HOME | varchar(100) |
  486. | STATE_ID | int(4) |
  487. | STATE_NAME | varchar(30) |
  488. +----------------+--------------+
  489.  
  490. Database: 371894_IC
  491. Table: INDIAMART_PROFILES
  492. [15 columns]
  493. +------------------+---------------+
  494. | Column | Type |
  495. +------------------+---------------+
  496. | ADDRESS | varchar(500) |
  497. | BUSINESS_DESC | varchar(2000) |
  498. | CATEGORY | varchar(200) |
  499. | CITY | varchar(100) |
  500. | COMPANY | varchar(200) |
  501. | CONTACT_PERSON | varchar(200) |
  502. | COUNTRY | varchar(100) |
  503. | EMAIL | varchar(100) |
  504. | FILE_NAME | varchar(100) |
  505. | PHONE | varchar(100) |
  506. | PIN | varchar(100) |
  507. | PRIMARY_INDUSTRY | int(4) |
  508. | SNO | int(50) |
  509. | STATE | varchar(100) |
  510. | WEBSITE | varchar(200) |
  511. +------------------+---------------+
  512.  
  513. Database: 371894_IC
  514. Table: IC_IT_CATEGORIES
  515. [3 columns]
  516. +---------+-------------+
  517. | Column | Type |
  518. +---------+-------------+
  519. | CAT_ID | smallint(6) |
  520. | CAT_NM | varchar(50) |
  521. | FILE_NM | varchar(50) |
  522. +---------+-------------+
  523.  
  524. Database: 371894_IC
  525. Table: IC_RATING
  526. [7 columns]
  527. +---------------+----------+
  528. | Column | Type |
  529. +---------------+----------+
  530. | CURRENT_VOTE | int(5) |
  531. | RATING_ID | int(5) |
  532. | SUB_CAT_ID | int(5) |
  533. | TOTAL_VOTES | int(5) |
  534. | VISITOR_IP | text |
  535. | VOTE_DATE | datetime |
  536. | WD_LISTING_ID | int(5) |
  537. +---------------+----------+
  538.  
  539. Database: 371894_IC
  540. Table: WD_EXECUTIVE
  541. [10 columns]
  542. +--------------+--------------+
  543. | Column | Type |
  544. +--------------+--------------+
  545. | CREATED_DATE | date |
  546. | CREATED_USER | varchar(100) |
  547. | EDESIGNATION | varchar(100) |
  548. | EEMAIL | varchar(100) |
  549. | EID | int(11) |
  550. | ENAME | varchar(100) |
  551. | EPHONE | varchar(20) |
  552. | ID | int(11) |
  553. | UPDATED_DATE | date |
  554. | UPDATED_USER | varchar(100) |
  555. +--------------+--------------+
  556.  
  557. Database: 371894_IC
  558. Table: IC_CONTACT_US
  559. [19 columns]
  560. +-------------+--------------+
  561. | Column | Type |
  562. +-------------+--------------+
  563. | ADDRESS | varchar(200) |
  564. | ADVERTISE | text |
  565. | CITY | varchar(30) |
  566. | COMMENTS | text |
  567. | COMPANY | text |
  568. | COUNTRY | varchar(20) |
  569. | EMAIL | text |
  570. | FAX | varchar(40) |
  571. | ID | int(6) |
  572. | MARKETING | text |
  573. | NAME | varchar(60) |
  574. | PHONE | varchar(40) |
  575. | POSTED_DT | date |
  576. | PRE_LISTING | text |
  577. | SERVICES | text |
  578. | STATE | varchar(20) |
  579. | TITLE | varchar(150) |
  580. | WEB_SITE | text |
  581. | ZIP | int(8) |
  582. +-------------+--------------+
  583.  
  584. Database: 371894_IC
  585. Table: markers
  586. [6 columns]
  587. +---------+-------------+
  588. | Column | Type |
  589. +---------+-------------+
  590. | address | varchar(80) |
  591. | id | int(11) |
  592. | lat | float(10,6) |
  593. | lng | float(10,6) |
  594. | name | varchar(60) |
  595. | type | varchar(30) |
  596. +---------+-------------+
  597.  
  598. Database: 371894_IC
  599. Table: IC_LOGISTICS_CATEGORIES
  600. [3 columns]
  601. +---------+-------------+
  602. | Column | Type |
  603. +---------+-------------+
  604. | CAT_ID | int(11) |
  605. | CAT_NM | varchar(50) |
  606. | FILE_NM | varchar(50) |
  607. +---------+-------------+
  608.  
  609. Database: 371894_IC
  610. Table: IC_LISTING_OWNERS
  611. [12 columns]
  612. +-----------------+--------------+
  613. | Column | Type |
  614. +-----------------+--------------+
  615. | BUSINESS_PHONE | varchar(50) |
  616. | COMMENTS | varchar(300) |
  617. | CONTACT_PERSON | varchar(200) |
  618. | CREATED_DT | timestamp |
  619. | DESIGNATION | varchar(100) |
  620. | DIRECTORY | int(11) |
  621. | LAST_UPDATED_BY | varchar(50) |
  622. | LAST_UPDATED_DT | date |
  623. | LISTING_ID | int(11) |
  624. | USER_ID | int(11) |
  625. | VERIFIED_BY | varchar(50) |
  626. | VERIFIED_DT | date |
  627. +-----------------+--------------+
  628.  
  629. Database: 371894_IC
  630. Table: BUG_STATUS
  631. [2 columns]
  632. +-----------+-------------+
  633. | Column | Type |
  634. +-----------+-------------+
  635. | STATUS | varchar(15) |
  636. | STATUS_ID | int(10) |
  637. +-----------+-------------+
  638.  
  639. Database: 371894_IC
  640. Table: reply
  641. [5 columns]
  642. +------------+---------------+
  643. | Column | Type |
  644. +------------+---------------+
  645. | ID | int(10) |
  646. | REPLY_DATE | date |
  647. | RID | int(10) |
  648. | SUBJECT | varchar(200) |
  649. | TITLE | varchar(1500) |
  650. +------------+---------------+
  651.  
  652. Database: 371894_IC
  653. Table: WD_ADDRESS_BACKUP
  654. [17 columns]
  655. +-----------------+--------------+
  656. | Column | Type |
  657. +-----------------+--------------+
  658. | ADDRESS_LN1 | varchar(100) |
  659. | ADDRESS_LN2 | varchar(100) |
  660. | ADDRESS_TYPE | varchar(50) |
  661. | CITY | varchar(50) |
  662. | COMPANY_NAME | varchar(100) |
  663. | CREATE_DT | timestamp |
  664. | CREATED_BY | varchar(20) |
  665. | EMAIL_ID | varchar(100) |
  666. | FAX | varchar(50) |
  667. | LAST_UPDATED_BY | varchar(20) |
  668. | LAST_UPDATED_DT | timestamp |
  669. | PHONE | varchar(100) |
  670. | POSTAL_CD | varchar(10) |
  671. | SOURCE_URL | varchar(100) |
  672. | STATE_ID | varchar(10) |
  673. | WD_COMPANY_NAME | varchar(100) |
  674. | WD_LISTING_ID | int(11) |
  675. +-----------------+--------------+
  676.  
  677. Database: 371894_IC
  678. Table: IC_GLOBAL_EXECUTIVE
  679. [11 columns]
  680. +---------------------+--------------+
  681. | Column | Type |
  682. +---------------------+--------------+
  683. | CREATED_BY_USERID | varchar(15) |
  684. | CREATED_DT | date |
  685. | EMAIL | varchar(100) |
  686. | EXE_DESIGNATION | varchar(300) |
  687. | EXECUTIVE_NAME | varchar(100) |
  688. | EXECUTIVE_SEQ_NUM | int(6) |
  689. | LAST_UPDATED_DT | date |
  690. | LAST_UPDATED_USERID | varchar(20) |
  691. | LISTING_ID | int(6) |
  692. | MOBILE_NUMBER | varchar(20) |
  693. | PHONE_NUMBER | varchar(20) |
  694. +---------------------+--------------+
  695.  
  696. Database: 371894_IC
  697. Table: PORTLAND_EMPLOYEES
  698. [27 columns]
  699. +-----------------------+--------------+
  700. | Column | Type |
  701. +-----------------------+--------------+
  702. | EMP_CONTACT_NUMBER | varchar(15) |
  703. | EMP_DATE_OF_JOINING | date |
  704. | EMP_DATE_OF_RELIEVING | date |
  705. | EMP_DESIGNATION | varchar(30) |
  706. | EMP_EMAIL_ID | varchar(50) |
  707. | EMP_FATHER_NAME | varchar(50) |
  708. | EMP_FIRST_NAME | varchar(50) |
  709. | EMP_ID | int(11) |
  710. | EMP_IMAGE | varchar(50) |
  711. | EMP_LAST_NAME | varchar(20) |
  712. | EMP_MIDDLE_NAME | varchar(20) |
  713. | EMP_QUALIFICATION | varchar(20) |
  714. | EMP_WORKING_LOCATION | varchar(30) |
  715. | PERMANENT_ADDRESS1 | varchar(100) |
  716. | PERMANENT_ADDRESS2 | varchar(100) |
  717. | PERMANENT_CITY | varchar(30) |
  718. | PERMANENT_COUNTRY | varchar(10) |
  719. | PERMANENT_DISTRICT | varchar(30) |
  720. | PERMANENT_POSTAL_CODE | int(10) |
  721. | PERMANENT_STATE | varchar(20) |
  722. | PRESENT_ADDRESS1 | varchar(100) |
  723. | PRESENT_ADDRESS2 | varchar(100) |
  724. | PRESENT_CITY | varchar(30) |
  725. | PRESENT_COUNTRY | varchar(10) |
  726. | PRESENT_DISTRICT | varchar(30) |
  727. | PRESENT_POSTAL_CODE | int(10) |
  728. | PRESENT_STATE | varchar(20) |
  729. +-----------------------+--------------+
  730.  
  731. Database: 371894_IC
  732. Table: BUSINESS_ADDRESS_BK
  733. [16 columns]
  734. +-----------------+--------------+
  735. | Column | Type |
  736. +-----------------+--------------+
  737. | ADDRESS_DESC | varchar(50) |
  738. | ADDRESS_LINE1 | varchar(150) |
  739. | ADDRESS_LINE2 | varchar(150) |
  740. | ADDRESS_SEQ_NUM | int(4) |
  741. | BUS_PROFILE_ID | int(11) |
  742. | CITY | varchar(50) |
  743. | CREATED_BY_USER | varchar(20) |
  744. | CREATED_DT | date |
  745. | EMAIL | varchar(60) |
  746. | FAX | varchar(30) |
  747. | LAST_UPDATED_DT | date |
  748. | LT_UP_BY_USER | varchar(20) |
  749. | MOBILE | varchar(30) |
  750. | PHONE | varchar(30) |
  751. | PINCODE | varchar(10) |
  752. | STATE_ID | varchar(2) |
  753. +-----------------+--------------+
  754.  
  755. Database: 371894_IC
  756. Table: NRI_TELL_A_FRIEND
  757. [8 columns]
  758. +----------------+--------------+
  759. | Column | Type |
  760. +----------------+--------------+
  761. | COMMENTS | varchar(500) |
  762. | NAME | varchar(50) |
  763. | NRI_LISTING_ID | int(6) |
  764. | REC_EMAIL1 | varchar(50) |
  765. | REC_EMAIL2 | varchar(50) |
  766. | REC_EMAIL3 | varchar(50) |
  767. | SNO | int(6) |
  768. | USER_EMAIL | varchar(50) |
  769. +----------------+--------------+
  770.  
  771. Database: 371894_IC
  772. Table: INDIAMART_PROFILES_31_1
  773. [15 columns]
  774. +------------------+----------------+
  775. | Column | Type |
  776. +------------------+----------------+
  777. | ADDRESS | varchar(500) |
  778. | BUSINESS_DESC | varchar(20000) |
  779. | CATEGORY | varchar(500) |
  780. | CITY | varchar(100) |
  781. | COMPANY | varchar(200) |
  782. | CONTACT_PERSON | varchar(200) |
  783. | COUNTRY | varchar(100) |
  784. | EMAIL | varchar(100) |
  785. | FILE_NAME | varchar(100) |
  786. | PHONE | varchar(100) |
  787. | PIN | varchar(100) |
  788. | PRIMARY_INDUSTRY | int(11) |
  789. | SNO | int(50) |
  790. | STATE | varchar(100) |
  791. | WEBSITE | varchar(200) |
  792. +------------------+----------------+
  793.  
  794. Database: 371894_IC
  795. Table: BUSINESS_EXECS
  796. [10 columns]
  797. +----------------------+--------------+
  798. | Column | Type |
  799. +----------------------+--------------+
  800. | BUS_PROFILE_ID | int(11) |
  801. | CREATED_BY_USER | varchar(20) |
  802. | CREATED_DT | date |
  803. | EXECUTIVE_DISGNATION | varchar(100) |
  804. | EXECUTIVE_EMAIL | varchar(100) |
  805. | EXECUTIVE_NAME | varchar(50) |
  806. | EXECUTIVE_PHONE | varchar(100) |
  807. | EXECUTIVE_SEQ_NUM | int(4) |
  808. | LAST_UPDATED_DT | date |
  809. | LT_UP_BY_USER | varchar(20) |
  810. +----------------------+--------------+
  811.  
  812. Database: 371894_IC
  813. Table: IC_GLOBAL_STATE
  814. [11 columns]
  815. +---------------------+--------------+
  816. | Column | Type |
  817. +---------------------+--------------+
  818. | COUNTRY_ID | int(3) |
  819. | CREATED_BY_USERID | varchar(20) |
  820. | CREATED_DT | date |
  821. | FOLDER_NAME | varchar(30) |
  822. | LAST_UPDATED_DT | date |
  823. | LAST_UPDATED_USERID | varchar(20) |
  824. | STATE_CODE | varchar(3) |
  825. | STATE_ID | int(4) |
  826. | STATE_IMAGE | varchar(30) |
  827. | STATE_NAME | varchar(30) |
  828. | STATE_URL | varchar(100) |
  829. +---------------------+--------------+
  830.  
  831. Database: 371894_IC
  832. Table: WEB_EXECUTIVE
  833. [10 columns]
  834. +--------------+--------------+
  835. | Column | Type |
  836. +--------------+--------------+
  837. | CREATED_DATE | date |
  838. | CREATED_USER | varchar(100) |
  839. | EDESIGNATION | varchar(100) |
  840. | EEMAIL | varchar(100) |
  841. | EID | int(11) |
  842. | ENAME | varchar(100) |
  843. | EPHONE | varchar(20) |
  844. | ID | int(11) |
  845. | UPDATED_DATE | date |
  846. | UPDATED_USER | varchar(100) |
  847. +--------------+--------------+
  848.  
  849. Database: 371894_IC
  850. Table: IC_CNC
  851. [1 column]
  852. +--------+---------+
  853. | Column | Type |
  854. +--------+---------+
  855. | ID | int(11) |
  856. +--------+---------+
  857.  
  858. Database: 371894_IC
  859. Table: PG_GALLERIES
  860. [12 columns]
  861. +-----------------+--------------+
  862. | Column | Type |
  863. +-----------------+--------------+
  864. | CATEGORY_ID | int(11) |
  865. | COMMENT | text |
  866. | CREATE_DT | datetime |
  867. | CREATED_BY | varchar(20) |
  868. | DESCRIPTION | text |
  869. | GALLERY_FOLDER | varchar(255) |
  870. | GALLERY_ID | int(11) |
  871. | LAST_UPDATED_BY | varchar(20) |
  872. | LAST_UPDATED_DT | datetime |
  873. | THUMBNAIL_IMG | varchar(255) |
  874. | TITLE | varchar(255) |
  875. | VIEW_COUNT | int(100) |
  876. +-----------------+--------------+
  877.  
  878. Database: 371894_IC
  879. Table: WD_LISTINGS
  880. [20 columns]
  881. +--------------------------+---------------+
  882. | Column | Type |
  883. +--------------------------+---------------+
  884. | CATEGORY_ID | int(11) |
  885. | COMPANY_DESC | varchar(2000) |
  886. | COMPANY_NAME | varchar(200) |
  887. | COMPANY_NEWS_FLG | varchar(1) |
  888. | CREATE_DT | timestamp |
  889. | CREATED_BY | varchar(20) |
  890. | FACEBOOK_URL | varchar(200) |
  891. | FB_REDIRECT_COUNT | int(11) |
  892. | LAST_UPDATED_BY | varchar(20) |
  893. | LAST_UPDATED_DT | timestamp |
  894. | LAST_VIEW_COUNT_EMAIL_DT | date |
  895. | LOGO | longblob |
  896. | LOGO_FILENAME | varchar(100) |
  897. | PROFILE_ID | int(11) |
  898. | UID | varchar(25) |
  899. | VERIFIED_DT | date |
  900. | VIEW_COUNT | int(11) |
  901. | WD_LISTING_ID | int(11) |
  902. | WEBSITE_URL | varchar(200) |
  903. | WS_REDIRECT_COUNT | int(11) |
  904. +--------------------------+---------------+
  905.  
  906. Database: 371894_IC
  907. Table: IC_CLS_CAMPAIGN
  908. [3 columns]
  909. +--------+---------------+
  910. | Column | Type |
  911. +--------+---------------+
  912. | DATE | timestamp |
  913. | EMAIL | varchar(5000) |
  914. | SNO | int(11) |
  915. +--------+---------------+
  916.  
  917. Database: 371894_IC
  918. Table: WEB_LISTINGS
  919. [16 columns]
  920. +------------------+---------------+
  921. | Column | Type |
  922. +------------------+---------------+
  923. | CATEGORY_ID | int(11) |
  924. | COMPANY | varchar(200) |
  925. | CREATE_DT | timestamp |
  926. | DESCRIPTION | varchar(1000) |
  927. | DESIGNATION | varchar(100) |
  928. | EMAIL | varchar(100) |
  929. | FACEBOOK_URL | varchar(300) |
  930. | FLAG | varchar(1) |
  931. | ID | int(11) |
  932. | LABEL | varchar(10) |
  933. | LAST_UPDATED_BY | varchar(20) |
  934. | LAST_UPDATED_DT | timestamp |
  935. | PHONE | varchar(100) |
  936. | PRE_CONTACT_NAME | varchar(100) |
  937. | VERIFIED_DT | date |
  938. | WEBSITE | varchar(200) |
  939. +------------------+---------------+
  940.  
  941. Database: 371894_IC
  942. Table: IC_AUTO_CATEGORIES
  943. [3 columns]
  944. +-----------+-------------+
  945. | Column | Type |
  946. +-----------+-------------+
  947. | CAT_ID | int(4) |
  948. | CAT_NM | varchar(60) |
  949. | FOLDER_NM | varchar(60) |
  950. +-----------+-------------+
  951.  
  952. Database: 371894_IC
  953. Table: IC_CONTACT_REPLY
  954. [5 columns]
  955. +-------------+---------------+
  956. | Column | Type |
  957. +-------------+---------------+
  958. | IC_EMAIL_ID | int(10) |
  959. | ID | int(10) |
  960. | REPLY_MSG | varchar(5000) |
  961. | SENT_ADD | varchar(200) |
  962. | SENT_DT | date |
  963. +-------------+---------------+
  964.  
  965. Database: 371894_IC
  966. Table: WD_KEYWORDS
  967. [1 column]
  968. +---------+-------------+
  969. | Column | Type |
  970. +---------+-------------+
  971. | KEYWORD | varchar(20) |
  972. +---------+-------------+
  973.  
  974. Database: 371894_IC
  975. Table: BP_EMAILS
  976. [7 columns]
  977. +------------+---------------+
  978. | Column | Type |
  979. +------------+---------------+
  980. | CREATED_DT | date |
  981. | EID | int(10) |
  982. | EMAIL_FRM | varchar(100) |
  983. | MESSAGE | varchar(5000) |
  984. | NAME | varchar(50) |
  985. | PROFILE_ID | int(10) |
  986. | SUBJECT | varchar(300) |
  987. +------------+---------------+
  988.  
  989. Database: 371894_IC
  990. Table: APPLICATION
  991. [4 columns]
  992. +----------+--------------+
  993. | Column | Type |
  994. +----------+--------------+
  995. | APP_ID | int(11) |
  996. | APP_NAME | varchar(100) |
  997. | FILE | varchar(50) |
  998. | FLAG | varchar(5) |
  999. +----------+--------------+
  1000.  
  1001. Database: 371894_IC
  1002. Table: SUBSCRIBE_EMAIL
  1003. [7 columns]
  1004. +-------------------+--------------+
  1005. | Column | Type |
  1006. +-------------------+--------------+
  1007. | APP_ID | int(11) |
  1008. | CONFIRMATION_CODE | varchar(100) |
  1009. | EMAIL | varchar(100) |
  1010. | EMAIL_ID | int(11) |
  1011. | FLAG | varchar(5) |
  1012. | LID | int(11) |
  1013. | SUB_DATE | date |
  1014. +-------------------+--------------+
  1015.  
  1016. Database: 371894_IC
  1017. Table: NRI_LISTINGS
  1018. [20 columns]
  1019. +-------------------+---------------+
  1020. | Column | Type |
  1021. +-------------------+---------------+
  1022. | BUSINESS_SUMMARY | varchar(2000) |
  1023. | CITY_NAME | varchar(150) |
  1024. | CREATED_DT | date |
  1025. | EMAIL | varchar(50) |
  1026. | FAX | varchar(50) |
  1027. | IMAGE_LOCATION1 | varchar(100) |
  1028. | IMAGE_LOCATION2 | varchar(100) |
  1029. | LAST_UPDATED_DT | date |
  1030. | NRI_ADDRESS_LINE1 | varchar(150) |
  1031. | NRI_CATEGORY_ID | int(4) |
  1032. | NRI_COMPANY | varchar(150) |
  1033. | NRI_LISTING_ID | int(6) |
  1034. | NRI_PHONE | varchar(50) |
  1035. | PHONE | varchar(20) |
  1036. | PINCODE | varchar(10) |
  1037. | PROFILE_ID | int(4) |
  1038. | STATE_CD | varchar(5) |
  1039. | STATE_ID | int(4) |
  1040. | URL | varchar(50) |
  1041. | VIEW_COUNT | int(11) |
  1042. +-------------------+---------------+
  1043.  
  1044. Database: 371894_IC
  1045. Table: IC_GLOBAL_COUNTRY
  1046. [10 columns]
  1047. +---------------------+--------------+
  1048. | Column | Type |
  1049. +---------------------+--------------+
  1050. | COUNTRY_CODE | varchar(3) |
  1051. | COUNTRY_ID | int(5) |
  1052. | COUNTRY_IMAGE | varchar(40) |
  1053. | COUNTRY_NAME | varchar(50) |
  1054. | CREATED_BY_USERID | varchar(20) |
  1055. | CREATED_DT | date |
  1056. | FOLDER_NAME | varchar(50) |
  1057. | LAST_UPDATED_DT | date |
  1058. | LAST_UPDATED_USERID | varchar(20) |
  1059. | ROOT_URL | varchar(150) |
  1060. +---------------------+--------------+
  1061.  
  1062. Database: 371894_IC
  1063. Table: ADDRESS_TYPE
  1064. [2 columns]
  1065. +--------------+--------------+
  1066. | Column | Type |
  1067. +--------------+--------------+
  1068. | ADDRESS_ID | int(11) |
  1069. | ADDRESS_TYPE | varchar(100) |
  1070. +--------------+--------------+
  1071.  
  1072. Database: 371894_IC
  1073. Table: IC_AUTO_CITIES
  1074. [3 columns]
  1075. +---------+-------------+
  1076. | Column | Type |
  1077. +---------+-------------+
  1078. | CITY_ID | int(4) |
  1079. | CITY_NM | varchar(50) |
  1080. | FILE_NM | varchar(50) |
  1081. +---------+-------------+
  1082.  
  1083. Database: 371894_IC
  1084. Table: IC_CITIES
  1085. [4 columns]
  1086. +----------------+-------------+
  1087. | Column | Type |
  1088. +----------------+-------------+
  1089. | CITY_ID | smallint(6) |
  1090. | CITY_NM | varchar(50) |
  1091. | FOLDER_NM | varchar(50) |
  1092. | MULTI_PAGE_FLG | varchar(1) |
  1093. +----------------+-------------+
  1094.  
  1095. Database: 371894_IC
  1096. Table: PROFILE_RESPONSES
  1097. [10 columns]
  1098. +-----------------+---------------+
  1099. | Column | Type |
  1100. +-----------------+---------------+
  1101. | BUS_PROFILE_ID | int(6) |
  1102. | COMMENTS | varchar(1000) |
  1103. | CREATED_DT | date |
  1104. | EMAIL | text |
  1105. | NAME | varchar(50) |
  1106. | PHONE | varchar(12) |
  1107. | REPLY_MESSAGE | varchar(2000) |
  1108. | REPLYED_BY_NAME | varchar(50) |
  1109. | REPLYED_DATE | date |
  1110. | SNO | int(5) |
  1111. +-----------------+---------------+
  1112.  
  1113. Database: 371894_IC
  1114. Table: PAYPAL_PAYMENTS
  1115. [8 columns]
  1116. +----------------+--------------+
  1117. | Column | Type |
  1118. +----------------+--------------+
  1119. | CREATED_DT | datetime |
  1120. | ID | int(6) |
  1121. | ITEM_ID | int(6) |
  1122. | ORDER_ID | varchar(25) |
  1123. | PAYMENT_AMOUNT | decimal(7,2) |
  1124. | PAYMENT_STATUS | varchar(25) |
  1125. | RECEIPT_ID | varchar(20) |
  1126. | TXN_ID | varchar(20) |
  1127. +----------------+--------------+
  1128.  
  1129. Database: 371894_IC
  1130. Table: IC_BUSINESS_LISTINGS_OLD
  1131. [19 columns]
  1132. +--------------+--------------+
  1133. | Column | Type |
  1134. +--------------+--------------+
  1135. | ADDR1 | varchar(100) |
  1136. | ADDR2 | varchar(100) |
  1137. | BUSINESS_NM | varchar(100) |
  1138. | CAT_ID | smallint(6) |
  1139. | CAT_NM | varchar(50) |
  1140. | CITY_ID | smallint(6) |
  1141. | CITY_NM | varchar(50) |
  1142. | CREATE_DT | date |
  1143. | DIRECTORY_ID | smallint(6) |
  1144. | EMAIL_ID | varchar(200) |
  1145. | FAX | varchar(50) |
  1146. | LAST_UPDT_DT | datetime |
  1147. | LISTING_ID | smallint(6) |
  1148. | PHONE | varchar(50) |
  1149. | PINCODE | varchar(10) |
  1150. | SOURCE | varchar(50) |
  1151. | SOURCE_URL | varchar(200) |
  1152. | USER_ID | varchar(100) |
  1153. | WEBSITE_URL | varchar(200) |
  1154. +--------------+--------------+
  1155.  
  1156. Database: 371894_IC
  1157. Table: IC_GLOBAL_CITY
  1158. [11 columns]
  1159. +---------------------+-------------+
  1160. | Column | Type |
  1161. +---------------------+-------------+
  1162. | CITY_FOLDER_NAME | varchar(50) |
  1163. | CITY_ID | int(8) |
  1164. | CITY_IMAGE | varchar(50) |
  1165. | CITY_NAME | varchar(50) |
  1166. | CITY_URL | varchar(50) |
  1167. | COUNTRY_ID | int(3) |
  1168. | CREATED_BY_USERID | varchar(20) |
  1169. | CREATED_DT | date |
  1170. | LAST_UPDATED_DT | date |
  1171. | LAST_UPDATED_USERID | varchar(20) |
  1172. | STATE_ID | int(4) |
  1173. +---------------------+-------------+
  1174.  
  1175. Database: 371894_IC
  1176. Table: IC_TEST_BUSINESS_LISTINGS
  1177. [24 columns]
  1178. +---------------+--------------+
  1179. | Column | Type |
  1180. +---------------+--------------+
  1181. | ADDR1 | varchar(100) |
  1182. | ADDR2 | varchar(100) |
  1183. | BUSINESS_NM | varchar(100) |
  1184. | CAT_ID | smallint(6) |
  1185. | CAT_NM | varchar(50) |
  1186. | CITY_ID | smallint(6) |
  1187. | CITY_NM | varchar(50) |
  1188. | CREATE_DT | datetime |
  1189. | DIRECTORY_ID | smallint(6) |
  1190. | EMAIL_ID | varchar(200) |
  1191. | FAX | varchar(50) |
  1192. | LAST_UPDT_DT | datetime |
  1193. | LISTING_ID | int(11) |
  1194. | LISTING_OWNER | int(11) |
  1195. | LOCALITY | varchar(100) |
  1196. | LOGO_URL | varchar(100) |
  1197. | MOBILE | varchar(50) |
  1198. | PHONE | varchar(50) |
  1199. | PINCODE | varchar(10) |
  1200. | SOURCE | varchar(50) |
  1201. | SOURCE_URL | varchar(200) |
  1202. | USER_ID | varchar(100) |
  1203. | VIEW_COUNT | int(11) |
  1204. | WEBSITE_URL | varchar(200) |
  1205. +---------------+--------------+
  1206.  
  1207. Database: 371894_IC
  1208. Table: IC_NEWS_COMMENTS
  1209. [6 columns]
  1210. +-------------+---------------+
  1211. | Column | Type |
  1212. +-------------+---------------+
  1213. | CID | int(11) |
  1214. | COMMENT | varchar(2000) |
  1215. | IS_APPROVED | varchar(1) |
  1216. | NAME | varchar(50) |
  1217. | NEWS_ID | int(11) |
  1218. | POSTED_DATE | date |
  1219. +-------------+---------------+
  1220.  
  1221. Database: 371894_IC
  1222. Table: IC_WD_PREMIUM_LISTINGS_ORDER
  1223. [19 columns]
  1224. +----------------+-----------------+
  1225. | Column | Type |
  1226. +----------------+-----------------+
  1227. | ADDR_LINE_1 | varchar(100) |
  1228. | ADDR_LINE_2 | varchar(100) |
  1229. | CAPTCHA | varchar(6) |
  1230. | CATEGORY_ID | smallint(6) |
  1231. | CITY | varchar(30) |
  1232. | CONTACT_EMAIL | varchar(100) |
  1233. | CONTACT_F_NAME | varchar(100) |
  1234. | CONTACT_FAX | varchar(50) |
  1235. | CONTACT_L_NAME | varchar(100) |
  1236. | CONTACT_MOBILE | varchar(50) |
  1237. | CONTACT_PHONE | varchar(50) |
  1238. | CREATE_DT | datetime |
  1239. | DESCRIPTION | varchar(1000) |
  1240. | ORDER_ID | smallint(6) |
  1241. | STATE | varchar(30) |
  1242. | STATUS | varchar(3) |
  1243. | TITLE | varchar(100) |
  1244. | WEBSITE_URL | varchar(200) |
  1245. | ZIP | int(6) unsigned |
  1246. +----------------+-----------------+
  1247.  
  1248. Database: 371894_IC
  1249. Table: BUG_ISSUES
  1250. [13 columns]
  1251. +-------------+---------------+
  1252. | Column | Type |
  1253. +-------------+---------------+
  1254. | APP_ID | int(3) |
  1255. | ASSIGN_TO | varchar(100) |
  1256. | BUG_ID | int(11) |
  1257. | CLOSE_DATE | date |
  1258. | CREATE_DATE | date |
  1259. | FILE_NAME | varchar(50) |
  1260. | ISSUE | varchar(4000) |
  1261. | NAME | varchar(25) |
  1262. | PRIORITY | varchar(100) |
  1263. | SOLUTION | varchar(4000) |
  1264. | STATUS | varchar(100) |
  1265. | TEST_BY | varchar(100) |
  1266. | TITLE | varchar(100) |
  1267. +-------------+---------------+
  1268.  
  1269. Database: 371894_IC
  1270. Table: HCS_TEMP_BUSINESS_LISTINGS
  1271. [24 columns]
  1272. +--------------+--------------+
  1273. | Column | Type |
  1274. +--------------+--------------+
  1275. | ADDR1 | varchar(100) |
  1276. | ADDR2 | varchar(100) |
  1277. | BUSINESS_NM | varchar(100) |
  1278. | CAT_ID | smallint(6) |
  1279. | CAT_NM | varchar(50) |
  1280. | CITY_ID | smallint(6) |
  1281. | CITY_NM | varchar(50) |
  1282. | COMMENTS | varchar(300) |
  1283. | CREATE_DT | date |
  1284. | DIRECTORY_ID | smallint(6) |
  1285. | EMAIL_ID | varchar(200) |
  1286. | FAX | varchar(50) |
  1287. | FLAG | char(1) |
  1288. | IC_ID | int(11) |
  1289. | LAST_UPDT_DT | datetime |
  1290. | LISTING_ID | int(11) |
  1291. | LOGO_NAME | varchar(50) |
  1292. | PHONE | varchar(50) |
  1293. | PINCODE | varchar(10) |
  1294. | SOURCE | varchar(50) |
  1295. | SOURCE_URL | varchar(200) |
  1296. | USER_ID | varchar(100) |
  1297. | VIEW_COUNT | int(11) |
  1298. | WEBSITE_URL | varchar(200) |
  1299. +--------------+--------------+
  1300.  
  1301. Database: 371894_IC
  1302. Table: IC_HOTEL_CITIES
  1303. [3 columns]
  1304. +-----------+-------------+
  1305. | Column | Type |
  1306. +-----------+-------------+
  1307. | CITY_ID | smallint(6) |
  1308. | CITY_NM | varchar(50) |
  1309. | FOLDER_NM | varchar(50) |
  1310. +-----------+-------------+
  1311.  
  1312. Database: 371894_IC
  1313. Table: DIRECTORY
  1314. [3 columns]
  1315. +----------+--------------+
  1316. | Column | Type |
  1317. +----------+--------------+
  1318. | DIR_CODE | varchar(50) |
  1319. | DIR_ID | int(11) |
  1320. | DIR_NAME | varchar(255) |
  1321. +----------+--------------+
  1322.  
  1323. Database: 371894_IC
  1324. Table: EMAIL_MANAGER
  1325. [8 columns]
  1326. +---------------+--------------+
  1327. | Column | Type |
  1328. +---------------+--------------+
  1329. | DIR_ID | int(10) |
  1330. | EMAIL_ID | int(11) |
  1331. | FLAG | varchar(255) |
  1332. | MSG_ID | int(11) |
  1333. | REFERRAL_CODE | varchar(500) |
  1334. | REFERRAL_FLAG | varchar(50) |
  1335. | SENT_DT | date |
  1336. | SNO | int(10) |
  1337. +---------------+--------------+
  1338.  
  1339. Database: 371894_IC
  1340. Table: PROFILE_RATING
  1341. [7 columns]
  1342. +----------------+----------+
  1343. | Column | Type |
  1344. +----------------+----------+
  1345. | BUS_PROFILE_ID | int(5) |
  1346. | CURRENT_VOTE | int(5) |
  1347. | PROFILE_CAT_ID | int(5) |
  1348. | RATING_ID | int(5) |
  1349. | TOTAL_VOTES | int(5) |
  1350. | VISITOR_IP | text |
  1351. | VOTE_DATE | datetime |
  1352. +----------------+----------+
  1353.  
  1354. Database: 371894_IC
  1355. Table: BUG_COMMENTS
  1356. [6 columns]
  1357. +------------+---------------+
  1358. | Column | Type |
  1359. +------------+---------------+
  1360. | BUG_ID | int(11) |
  1361. | COMMENT | varchar(5000) |
  1362. | CREATE_DT | timestamp |
  1363. | ID | int(11) |
  1364. | POSTED_BY | varchar(50) |
  1365. | UPDATED_DT | timestamp |
  1366. +------------+---------------+
  1367.  
  1368. Database: 371894_IC
  1369. Table: WD_LISTINGS_BK
  1370. [10 columns]
  1371. +-----------------+---------------+
  1372. | Column | Type |
  1373. +-----------------+---------------+
  1374. | CATEGORY_ID | int(11) |
  1375. | COMPANY_DESC | varchar(1000) |
  1376. | COMPANY_NAME | varchar(200) |
  1377. | CREATE_DT | timestamp |
  1378. | CREATED_BY | varchar(20) |
  1379. | LAST_UPDATED_BY | varchar(20) |
  1380. | LAST_UPDATED_DT | timestamp |
  1381. | LOGO_FILENAME | varchar(100) |
  1382. | WD_LISTING_ID | int(11) |
  1383. | WEBSITE_URL | varchar(200) |
  1384. +-----------------+---------------+
  1385.  
  1386. Database: 371894_IC
  1387. Table: EMAIL_BLACKLIST
  1388. [6 columns]
  1389. +--------------+-------------+
  1390. | Column | Type |
  1391. +--------------+-------------+
  1392. | CREATED_BY | varchar(50) |
  1393. | CREATED_DATE | date |
  1394. | EMAIL | varchar(50) |
  1395. | SNO | int(11) |
  1396. | UPDATED_BY | varchar(50) |
  1397. | UPDATED_DATE | date |
  1398. +--------------+-------------+
  1399.  
  1400. Database: 371894_IC
  1401. Table: MESSAGES
  1402. [6 columns]
  1403. +-----------+---------------+
  1404. | Column | Type |
  1405. +-----------+---------------+
  1406. | DIR_ID | int(11) |
  1407. | MSG_DES | varchar(3000) |
  1408. | MSG_ID | int(11) |
  1409. | MSG_TITLE | varchar(500) |
  1410. | SEND_MAIL | varchar(150) |
  1411. | SIGNATURE | varchar(500) |
  1412. +-----------+---------------+
  1413.  
  1414. Database: 371894_IC
  1415. Table: IC_TRANSLATE_CODES
  1416. [9 columns]
  1417. +---------------+-------------+
  1418. | Column | Type |
  1419. +---------------+-------------+
  1420. | CODE_CATEGORY | varchar(20) |
  1421. | CODE_ID | varchar(10) |
  1422. | CODE_NAME | varchar(20) |
  1423. | CODE_VALUE | varchar(50) |
  1424. | CREATE_DT | date |
  1425. | CREATED_BY | varchar(50) |
  1426. | DISPLAY_ORDER | smallint(6) |
  1427. | LAST_UPDT_BY | varchar(50) |
  1428. | LAST_UPDT_DT | date |
  1429. +---------------+-------------+
  1430.  
  1431. Database: 371894_IC
  1432. Table: IC_RESTAURANT_DTL
  1433. [34 columns]
  1434. +--------------------------+--------------+
  1435. | Column | Type |
  1436. +--------------------------+--------------+
  1437. | AIR_CONDITIONED | varchar(1) |
  1438. | ALCOHOL_SERVED | char(1) |
  1439. | CATERING | varchar(1) |
  1440. | CREATED_BY | varchar(20) |
  1441. | CREATED_DT | date |
  1442. | CREDIT_CARDS_ACCEPTED | varchar(1) |
  1443. | DATA_PROVIDED_BY | varchar(50) |
  1444. | DATA_PROVIDER_EMAIL | varchar(100) |
  1445. | DATA_PROVIDER_PHONE | varchar(20) |
  1446. | FREE_WIFI | varchar(1) |
  1447. | GOOD_FOR_KIDS | varchar(1) |
  1448. | HAPPY_HOURS | varchar(50) |
  1449. | HAS_TV | varchar(1) |
  1450. | HOME_DELIVERY | varchar(1) |
  1451. | HOME_DELIVERY_CONDITIONS | varchar(100) |
  1452. | HOME_DELIVERY_TIME | varchar(100) |
  1453. | HOME_DELIVERY_TIMINGS | varchar(50) |
  1454. | LAST_UPDATED_BY | varchar(20) |
  1455. | LAST_UPDATED_DT | date |
  1456. | LISTING_ID | int(11) |
  1457. | LIVE_PERFORMANCES | varchar(1) |
  1458. | MEAL_COUPONS_ACCEPTED | varchar(50) |
  1459. | MIN_DELIVERY_ORDER_AMT | varchar(20) |
  1460. | NOISE_LEVEL | smallint(6) |
  1461. | OUTDOOR_SEATING | varchar(1) |
  1462. | PARKING | char(6) |
  1463. | PRICE_RANGE_FOR_TWO | smallint(6) |
  1464. | PURE_VEGETARIAN | varchar(1) |
  1465. | SMOKING_AREA | varchar(1) |
  1466. | TAKE_OUT | varchar(1) |
  1467. | TAKE_RESERVATIONS | smallint(6) |
  1468. | VALET_PARKING | varchar(1) |
  1469. | VAT_APPLIED | varchar(1) |
  1470. | WAITER_SERVICE | varchar(1) |
  1471. +--------------------------+--------------+
  1472.  
  1473. Database: 371894_IC
  1474. Table: IC_HOTELS
  1475. [13 columns]
  1476. +-------------+--------------+
  1477. | Column | Type |
  1478. +-------------+--------------+
  1479. | ADDR1 | varchar(100) |
  1480. | ADDR2 | varchar(100) |
  1481. | BUSINESS_NM | varchar(100) |
  1482. | CAT_ID | smallint(6) |
  1483. | CAT_NM | varchar(50) |
  1484. | CITY_ID | smallint(6) |
  1485. | CITY_NM | varchar(100) |
  1486. | EMAIL | varchar(100) |
  1487. | FAX | varchar(50) |
  1488. | LISTING_ID | smallint(6) |
  1489. | PHONE | varchar(50) |
  1490. | PINCODE | varchar(10) |
  1491. | WEBSITE_URL | varchar(100) |
  1492. +-------------+--------------+
  1493.  
  1494. Database: 371894_IC
  1495. Table: INDIAMART_PROFILES_19_5
  1496. [14 columns]
  1497. +----------------------+---------------+
  1498. | Column | Type |
  1499. +----------------------+---------------+
  1500. | ADDRESS | varchar(500) |
  1501. | BUSINESS_DESC | varchar(2000) |
  1502. | CATEGORY | varchar(500) |
  1503. | CITY | varchar(100) |
  1504. | COMPANY | varchar(200) |
  1505. | COMPANY_ID | int(11) |
  1506. | CONTACT_PERSON | varchar(200) |
  1507. | COUNTRY | varchar(100) |
  1508. | PHONE | varchar(100) |
  1509. | PIN | varchar(100) |
  1510. | PROMOTIONAL_EMAIL_ID | varchar(100) |
  1511. | SNO | int(50) |
  1512. | STATE | varchar(100) |
  1513. | WEBSITE | varchar(200) |
  1514. +----------------------+---------------+
  1515.  
  1516. Database: 371894_IC
  1517. Table: INDIAMART_PROFILES_29_10
  1518. [15 columns]
  1519. +------------------+---------------+
  1520. | Column | Type |
  1521. +------------------+---------------+
  1522. | ADDRESS | varchar(500) |
  1523. | BUSINESS_DESC | varchar(2000) |
  1524. | CATEGORY | varchar(500) |
  1525. | CITY | varchar(100) |
  1526. | COMPANY | varchar(200) |
  1527. | CONTACT_PERSON | varchar(200) |
  1528. | COUNTRY | varchar(100) |
  1529. | EMAIL | varchar(100) |
  1530. | FILE_NAME | varchar(100) |
  1531. | PHONE | varchar(100) |
  1532. | PIN | varchar(100) |
  1533. | PRIMARY_INDUSTRY | int(11) |
  1534. | SNO | int(50) |
  1535. | STATE | varchar(100) |
  1536. | WEBSITE | varchar(200) |
  1537. +------------------+---------------+
  1538.  
  1539. Database: 371894_IC
  1540. Table: INDIAMART_PROFILES_29_11
  1541. [15 columns]
  1542. +------------------+----------------+
  1543. | Column | Type |
  1544. +------------------+----------------+
  1545. | ADDRESS | varchar(500) |
  1546. | BUSINESS_DESC | varchar(20000) |
  1547. | CATEGORY | varchar(500) |
  1548. | CITY | varchar(100) |
  1549. | COMPANY | varchar(200) |
  1550. | CONTACT_PERSON | varchar(200) |
  1551. | COUNTRY | varchar(100) |
  1552. | EMAIL | varchar(100) |
  1553. | FILE_NAME | varchar(100) |
  1554. | PHONE | varchar(100) |
  1555. | PIN | varchar(100) |
  1556. | PRIMARY_INDUSTRY | int(11) |
  1557. | SNO | int(50) |
  1558. | STATE | varchar(100) |
  1559. | WEBSITE | varchar(200) |
  1560. +------------------+----------------+
  1561.  
  1562. Database: 371894_IC
  1563. Table: WD_ADDRESS
  1564. [19 columns]
  1565. +-----------------+--------------+
  1566. | Column | Type |
  1567. +-----------------+--------------+
  1568. | ADDRESS_LN1 | varchar(100) |
  1569. | ADDRESS_LN2 | varchar(100) |
  1570. | ADDRESS_TYPE | varchar(50) |
  1571. | CITY | varchar(50) |
  1572. | COMPANY_NAME | varchar(100) |
  1573. | CREATE_DT | timestamp |
  1574. | CREATED_BY | varchar(20) |
  1575. | EMAIL_ID | varchar(100) |
  1576. | FAX | varchar(50) |
  1577. | LAST_UPDATED_BY | varchar(20) |
  1578. | LAST_UPDATED_DT | timestamp |
  1579. | MOBILE | varchar(100) |
  1580. | PHONE | varchar(100) |
  1581. | POSTAL_CD | varchar(10) |
  1582. | SOURCE_URL | varchar(100) |
  1583. | STATE_ID | varchar(10) |
  1584. | WD_ADDRESS_ID | int(11) |
  1585. | WD_COMPANY_NAME | varchar(100) |
  1586. | WD_LISTING_ID | int(11) |
  1587. +-----------------+--------------+
  1588.  
  1589. Database: 371894_IC
  1590. Table: NRI_RATING
  1591. [7 columns]
  1592. +----------------+----------+
  1593. | Column | Type |
  1594. +----------------+----------+
  1595. | CURRENT_VOTE | int(5) |
  1596. | NRI_CAT_ID | int(5) |
  1597. | NRI_LISTING_ID | int(5) |
  1598. | RATING_ID | int(5) |
  1599. | TOTAL_VOTES | int(5) |
  1600. | VISITOR_IP | text |
  1601. | VOTE_DATE | datetime |
  1602. +----------------+----------+
  1603.  
  1604. Database: 371894_IC
  1605. Table: BUG_UPLOADES
  1606. [5 columns]
  1607. +-------------+--------------+
  1608. | Column | Type |
  1609. +-------------+--------------+
  1610. | BID | int(3) |
  1611. | CREATE_DATE | timestamp |
  1612. | FILE_NAME | varchar(200) |
  1613. | ID | int(11) |
  1614. | UPLOADED_BY | varchar(30) |
  1615. +-------------+--------------+
  1616.  
  1617. Database: 371894_IC
  1618. Table: IC_GLOBAL_WD_CAT
  1619. [10 columns]
  1620. +---------------------+---------------+
  1621. | Column | Type |
  1622. +---------------------+---------------+
  1623. | CAT_ID | int(6) |
  1624. | CAT_NAME | varchar(50) |
  1625. | CREATED_BY_USERID | varchar(15) |
  1626. | CREATED_DT | date |
  1627. | DESCR | varchar(1000) |
  1628. | FILE_NAME | varchar(60) |
  1629. | FOLDER_NAME | varchar(60) |
  1630. | IMAGE_FILE | varchar(60) |
  1631. | LAST_UPDATED_DT | date |
  1632. | LAST_UPDATED_USERID | varchar(15) |
  1633. +---------------------+---------------+
  1634.  
  1635. Database: 371894_IC
  1636. Table: BUSINESS_ADDRESS
  1637. [16 columns]
  1638. +-----------------+--------------+
  1639. | Column | Type |
  1640. +-----------------+--------------+
  1641. | ADDRESS_DESC | varchar(50) |
  1642. | ADDRESS_LINE1 | varchar(150) |
  1643. | ADDRESS_LINE2 | varchar(150) |
  1644. | ADDRESS_SEQ_NUM | int(4) |
  1645. | BUS_PROFILE_ID | int(11) |
  1646. | CITY | varchar(50) |
  1647. | CREATED_BY_USER | varchar(20) |
  1648. | CREATED_DT | date |
  1649. | EMAIL | varchar(60) |
  1650. | FAX | varchar(30) |
  1651. | LAST_UPDATED_DT | date |
  1652. | LT_UP_BY_USER | varchar(20) |
  1653. | MOBILE | varchar(30) |
  1654. | PHONE | varchar(30) |
  1655. | PINCODE | varchar(10) |
  1656. | STATE_ID | varchar(2) |
  1657. +-----------------+--------------+
  1658.  
  1659. Database: 371894_IC
  1660. Table: IC_CONTACT_MANAGER
  1661. [8 columns]
  1662. +---------------+--------------+
  1663. | Column | Type |
  1664. +---------------+--------------+
  1665. | DIR_ID | int(10) |
  1666. | FLAG | varchar(10) |
  1667. | IC_EMAIL_ID | int(10) |
  1668. | ID | int(10) |
  1669. | MSG_ID | int(10) |
  1670. | REFERRAL_CODE | varchar(150) |
  1671. | REFERRAL_FLAG | varchar(150) |
  1672. | SENT_DT | date |
  1673. +---------------+--------------+
  1674.  
  1675. Database: 371894_IC
  1676. Table: INDIA_STATES
  1677. [2 columns]
  1678. +------------+-------------+
  1679. | Column | Type |
  1680. +------------+-------------+
  1681. | STATE_ID | varchar(2) |
  1682. | STATE_NAME | varchar(32) |
  1683. +------------+-------------+
  1684.  
  1685. Database: 371894_IC
  1686. Table: BUSINESS_PROFILE
  1687. [33 columns]
  1688. +------------------------+---------------+
  1689. | Column | Type |
  1690. +------------------------+---------------+
  1691. | BSE_STK_SYMBOL | varchar(12) |
  1692. | BUS_PROFILE_ID | int(11) |
  1693. | BUSINESS_NAME | varchar(100) |
  1694. | BUSINESS_SUMMARY | varchar(4000) |
  1695. | CREATED_BY_USER | varchar(20) |
  1696. | CREATED_DT | text |
  1697. | CUST_ENTERED_IND | varchar(100) |
  1698. | IMAGE | varchar(30) |
  1699. | INDIACATALOG_URL | varchar(100) |
  1700. | LAST_UPDATED_DT | text |
  1701. | LOGO_IMAGE | varchar(50) |
  1702. | LT_UP_BY_USER | varchar(20) |
  1703. | NBR_OF_EMPLOYEES | int(10) |
  1704. | NSE_STK_SYMBOL | varchar(12) |
  1705. | OTHER_STOCK_SYMBOL | varchar(100) |
  1706. | PORFILE_NAME | varchar(100) |
  1707. | PRI_CONTACT_EMAIL | varchar(100) |
  1708. | PRI_CONTACT_FIRST_NAME | varchar(70) |
  1709. | PRI_CONTACT_LAST_NAME | varchar(32) |
  1710. | PRI_CONTACT_PHONE | varchar(100) |
  1711. | PRIMARY_INDUSTRY | int(4) |
  1712. | PRODUCTS_SUMMARY | varchar(4000) |
  1713. | PUBLIC_TRADED_CO | varchar(1) |
  1714. | SEC_CONTACT_EMAIL | varchar(50) |
  1715. | SEC_CONTACT_FIRST_NAME | varchar(32) |
  1716. | SEC_CONTACT_LAST_NAME | varchar(32) |
  1717. | SEC_CONTACT_PHONE | varchar(20) |
  1718. | SERVICES_SUMMARY | varchar(4000) |
  1719. | SNO | int(11) |
  1720. | SOURCE | varchar(50) |
  1721. | VERIFIED_DT | date |
  1722. | VIEW_COUNT | int(11) |
  1723. | WEBSITE_URL | varchar(100) |
  1724. +------------------------+---------------+
  1725.  
  1726. Database: 371894_IC
  1727. Table: IC_NEWS
  1728. [15 columns]
  1729. +---------------------+--------------+
  1730. | Column | Type |
  1731. +---------------------+--------------+
  1732. | CREATE_DT | date |
  1733. | LAST_UPDT_DT | date |
  1734. | LONG_NEWS | text |
  1735. | NEWS_DT | date |
  1736. | NEWS_ID | mediumint(9) |
  1737. | NEWS_PHOTO | varchar(100) |
  1738. | NEWS_SOURCE | smallint(6) |
  1739. | NEWS_TITLE | varchar(255) |
  1740. | NEWS_URL | varchar(500) |
  1741. | RELATED_TO_COMPANY1 | int(11) |
  1742. | RELATED_TO_COMPANY2 | int(11) |
  1743. | RELATED_TO_COMPANY3 | int(11) |
  1744. | RELATED_TO_COMPANY4 | int(11) |
  1745. | SHORT_NEWS | text |
  1746. | VIEW_COUNT | int(11) |
  1747. +---------------------+--------------+
  1748.  
  1749. Database: 371894_IC
  1750. Table: TMP_VIJAYAWADA
  1751. [7 columns]
  1752. +-------------+--------------+
  1753. | Column | Type |
  1754. +-------------+--------------+
  1755. | ADDR | varchar(100) |
  1756. | BUSINESS_NM | varchar(100) |
  1757. | CAT_ID | smallint(6) |
  1758. | CAT_NM | varchar(100) |
  1759. | FAX | varchar(100) |
  1760. | FILLER1 | varchar(100) |
  1761. | PHONE | varchar(100) |
  1762. +-------------+--------------+
  1763.  
  1764. Database: 371894_IC
  1765. Table: WD_CATEGORIES
  1766. [9 columns]
  1767. +--------------------+--------------+
  1768. | Column | Type |
  1769. +--------------------+--------------+
  1770. | CATEGORY_FOLDER | varchar(50) |
  1771. | CATEGORY_ID | int(11) |
  1772. | CATEGORY_NAME | varchar(50) |
  1773. | CREATE_DT | timestamp |
  1774. | CREATED_BY | varchar(20) |
  1775. | KEYWORDS | varchar(500) |
  1776. | LAST_UPDATED_BY | varchar(20) |
  1777. | LAST_UPDATED_DT | timestamp |
  1778. | PARENT_CATEGORY_ID | int(11) |
  1779. +--------------------+--------------+
  1780.  
  1781. Database: 371894_IC
  1782. Table: EMAIL_SENT_LOG
  1783. [8 columns]
  1784. +------------+--------------+
  1785. | Column | Type |
  1786. +------------+--------------+
  1787. | DATE | date |
  1788. | APP_ID | int(11) |
  1789. | EMAIL_FROM | varchar(100) |
  1790. | EMAIL_TO | varchar(100) |
  1791. | EMAIL_TYPE | varchar(200) |
  1792. | LISTING_ID | int(11) |
  1793. | SENT_DTTM | datetime |
  1794. | VIEW_COUNT | int(11) |
  1795. +------------+--------------+
  1796.  
  1797. Database: 371894_IC
  1798. Table: IC_BL_CATEGORIES
  1799. [3 columns]
  1800. +---------+-------------+
  1801. | Column | Type |
  1802. +---------+-------------+
  1803. | CAT_ID | int(11) |
  1804. | CAT_NM | varchar(50) |
  1805. | FILE_NM | varchar(50) |
  1806. +---------+-------------+
  1807.  
  1808. Database: 371894_IC
  1809. Table: YP_ERROR_REPORT
  1810. [14 columns]
  1811. +-------------+--------------+
  1812. | Column | Type |
  1813. +-------------+--------------+
  1814. | ADDRESS | varchar(50) |
  1815. | CLOSED | varchar(20) |
  1816. | CREATED_DT | date |
  1817. | DESCRIPTION | varchar(300) |
  1818. | EMAIL | varchar(100) |
  1819. | EMAIL1 | varchar(20) |
  1820. | FAX | varchar(20) |
  1821. | ID | int(11) |
  1822. | LID | int(11) |
  1823. | OTHER | varchar(20) |
  1824. | PHONE | varchar(50) |
  1825. | STATUS | char(1) |
  1826. | UPDATED_DT | date |
  1827. | URL | varchar(20) |
  1828. +-------------+--------------+
  1829.  
  1830. Database: 371894_IC
  1831. Table: IC_BUSINESS_LISTINGS
  1832. [24 columns]
  1833. +---------------+--------------+
  1834. | Column | Type |
  1835. +---------------+--------------+
  1836. | ADDR1 | varchar(100) |
  1837. | ADDR2 | varchar(100) |
  1838. | BUSINESS_NM | varchar(100) |
  1839. | CAT_ID | smallint(6) |
  1840. | CAT_NM | varchar(50) |
  1841. | CITY_ID | smallint(6) |
  1842. | CITY_NM | varchar(50) |
  1843. | CREATE_DT | date |
  1844. | DIRECTORY_ID | smallint(6) |
  1845. | EMAIL_ID | varchar(200) |
  1846. | FAX | varchar(50) |
  1847. | LAST_UPDT_DT | datetime |
  1848. | LISTING_ID | int(11) |
  1849. | LISTING_OWNER | int(11) |
  1850. | LOCALITY | varchar(100) |
  1851. | LOGO_URL | varchar(100) |
  1852. | MOBILE | varchar(50) |
  1853. | PHONE | varchar(50) |
  1854. | PINCODE | varchar(10) |
  1855. | SOURCE | varchar(50) |
  1856. | SOURCE_URL | varchar(200) |
  1857. | USER_ID | varchar(100) |
  1858. | VIEW_COUNT | int(11) |
  1859. | WEBSITE_URL | varchar(200) |
  1860. +---------------+--------------+
  1861.  
  1862. Database: 371894_IC
  1863. Table: YP_VIJAYAWADA
  1864. [14 columns]
  1865. +----------------+--------------+
  1866. | Column | Type |
  1867. +----------------+--------------+
  1868. | ADDR1 | varchar(100) |
  1869. | ADDR2 | varchar(100) |
  1870. | BUSINESS_NM | varchar(100) |
  1871. | CAT_ID | smallint(6) |
  1872. | CAT_NM | varchar(100) |
  1873. | CITY_ID | smallint(6) |
  1874. | CITY_NM | varchar(50) |
  1875. | CONTACT_PERSON | varchar(100) |
  1876. | EMAIL_ID | varchar(100) |
  1877. | FAX | varchar(50) |
  1878. | MOBILE | varchar(50) |
  1879. | PHONE | varchar(50) |
  1880. | PINCODE | varchar(10) |
  1881. | WEBSITE_URL | varchar(100) |
  1882. +----------------+--------------+
  1883.  
  1884. Database: 371894_IC
  1885. Table: IC_GLOBAL_WD_LISTING_FEB4
  1886. [16 columns]
  1887. +---------------------+---------------+
  1888. | Column | Type |
  1889. +---------------------+---------------+
  1890. | COUNT | int(11) |
  1891. | COMPANY_DESCR | varchar(4000) |
  1892. | COMPANY_LOGO_FILE | varchar(100) |
  1893. | COMPANY_NAME | varchar(100) |
  1894. | COMPANY_WEB_URL | varchar(100) |
  1895. | CONTACT_INFO_URL | varchar(150) |
  1896. | CREATED_BY_USERID | varchar(15) |
  1897. | CREATED_DT | date |
  1898. | LAST_UPDATED_DT | date |
  1899. | LAST_UPDATED_USERID | varchar(15) |
  1900. | PARENT_CAT_ID | int(4) |
  1901. | STOCK_CODE | varchar(30) |
  1902. | STOCK_EXCHANGE | varchar(30) |
  1903. | SUB_CAT_ID | int(4) |
  1904. | TOLLFREE_NBR | varchar(20) |
  1905. | WD_LISTING_ID | int(6) |
  1906. +---------------------+---------------+
  1907.  
  1908. Database: 371894_IC
  1909. Table: PG_IMAGES
  1910. [8 columns]
  1911. +-----------------+--------------+
  1912. | Column | Type |
  1913. +-----------------+--------------+
  1914. | CREATED_DT | datetime |
  1915. | DESCRIPTION | text |
  1916. | GALLERY_ID | int(11) |
  1917. | IMAGE_FILE_NM | varchar(255) |
  1918. | IMAGE_ID | int(11) |
  1919. | LAST_UPDATED_DT | datetime |
  1920. | TITLE | varchar(255) |
  1921. | VIEW_COUNT | int(11) |
  1922. +-----------------+--------------+
  1923.  
  1924. Database: 371894_IC
  1925. Table: WD_RESPONSES
  1926. [10 columns]
  1927. +-----------------+---------------+
  1928. | Column | Type |
  1929. +-----------------+---------------+
  1930. | COMMENTS | varchar(1000) |
  1931. | CREATED_DT | date |
  1932. | EMAIL | text |
  1933. | NAME | varchar(50) |
  1934. | PHONE | varchar(12) |
  1935. | REPLY_MESSAGE | varchar(2000) |
  1936. | REPLYED_BY_NAME | varchar(50) |
  1937. | REPLYED_DATE | date |
  1938. | SNO | int(5) |
  1939. | WD_LISTING_ID | int(6) |
  1940. +-----------------+---------------+
  1941.  
  1942. Database: 371894_IC
  1943. Table: IC_GLOBAL_ADDADDRESS
  1944. [17 columns]
  1945. +---------------------+--------------+
  1946. | Column | Type |
  1947. +---------------------+--------------+
  1948. | ADDRESS1 | varchar(200) |
  1949. | ADDRESS2 | varchar(150) |
  1950. | ADDRESS_ID | int(6) |
  1951. | ADDRESS_TYPE | varchar(50) |
  1952. | CITY | varchar(50) |
  1953. | COUNTRY | varchar(50) |
  1954. | CREATED_BY_USERID | varchar(20) |
  1955. | CREATED_DT | date |
  1956. | EMAIL_ID | varchar(100) |
  1957. | FAX | text |
  1958. | LAST_UPDATED_DT | date |
  1959. | LAST_UPDATED_USERID | varchar(20) |
  1960. | MOBILE_NO | text |
  1961. | PHONE_NO | text |
  1962. | PINCODE | text |
  1963. | STATE | varchar(50) |
  1964. | WD_LISTING_ID | int(6) |
  1965. +---------------------+--------------+
  1966.  
  1967. Database: 371894_IC
  1968. Table: QUOTES
  1969. [5 columns]
  1970. +------------+--------------+
  1971. | Column | Type |
  1972. +------------+--------------+
  1973. | CATEGORY | varchar(30) |
  1974. | CREATED_DT | date |
  1975. | QUOTE_BY | varchar(100) |
  1976. | QUOTE_ID | int(11) |
  1977. | QUOTE_TXT | varchar(200) |
  1978. +------------+--------------+
  1979.  
  1980. Database: 371894_IC
  1981. Table: BUSINESS_PROFILE_BK
  1982. [32 columns]
  1983. +------------------------+---------------+
  1984. | Column | Type |
  1985. +------------------------+---------------+
  1986. | BSE_STK_SYMBOL | varchar(12) |
  1987. | BUS_PROFILE_ID | int(11) |
  1988. | BUSINESS_NAME | varchar(100) |
  1989. | BUSINESS_SUMMARY | varchar(4000) |
  1990. | CREATED_BY_USER | varchar(20) |
  1991. | CREATED_DT | text |
  1992. | CUST_ENTERED_IND | varchar(100) |
  1993. | IMAGE | varchar(30) |
  1994. | INDIACATALOG_URL | varchar(100) |
  1995. | LAST_UPDATED_DT | text |
  1996. | LOGO_IMAGE | varchar(50) |
  1997. | LT_UP_BY_USER | varchar(20) |
  1998. | NBR_OF_EMPLOYEES | int(10) |
  1999. | NSE_STK_SYMBOL | varchar(12) |
  2000. | OTHER_STOCK_SYMBOL | varchar(100) |
  2001. | PORFILE_NAME | varchar(100) |
  2002. | PRI_CONTACT_EMAIL | varchar(100) |
  2003. | PRI_CONTACT_FIRST_NAME | varchar(70) |
  2004. | PRI_CONTACT_LAST_NAME | varchar(32) |
  2005. | PRI_CONTACT_PHONE | varchar(100) |
  2006. | PRIMARY_INDUSTRY | int(4) |
  2007. | PRODUCTS_SUMMARY | varchar(4000) |
  2008. | PUBLIC_TRADED_CO | varchar(1) |
  2009. | SEC_CONTACT_EMAIL | varchar(50) |
  2010. | SEC_CONTACT_FIRST_NAME | varchar(32) |
  2011. | SEC_CONTACT_LAST_NAME | varchar(32) |
  2012. | SEC_CONTACT_PHONE | varchar(20) |
  2013. | SERVICES_SUMMARY | varchar(4000) |
  2014. | SNO | int(11) |
  2015. | SOURCE | varchar(50) |
  2016. | VERIFIED_DT | date |
  2017. | WEBSITE_URL | varchar(100) |
  2018. +------------------------+---------------+
  2019.  
  2020. Database: 371894_IC
  2021. Table: NRI_CATEGORIES
  2022. [6 columns]
  2023. +-----------------------+--------------+
  2024. | Column | Type |
  2025. +-----------------------+--------------+
  2026. | FILE_SIZE | int(6) |
  2027. | FILENAME | varchar(100) |
  2028. | LAST_PUBLISHED | timestamp |
  2029. | NRI_CATEGORY_ID | int(4) |
  2030. | NRI_CATEGORY_NAME | varchar(30) |
  2031. | NRI_PARENTCATEGORY_ID | int(4) |
  2032. +-----------------------+--------------+
  2033.  
  2034. Database: 371894_IC
  2035. Table: HCS_MEMBERS_DB
  2036. [19 columns]
  2037. +--------------------+--------------+
  2038. | Column | Type |
  2039. +--------------------+--------------+
  2040. | ACCOUNT_ENABLE_FLG | varchar(2) |
  2041. | ADDRESS | varchar(100) |
  2042. | AGE | int(3) |
  2043. | CITY | varchar(50) |
  2044. | CONFIRM_CODE | varchar(65) |
  2045. | COUNTRY | varchar(50) |
  2046. | CREATED_DT | date |
  2047. | EMAIL | varchar(100) |
  2048. | FEEDBACK | varchar(200) |
  2049. | ID | int(6) |
  2050. | LAST_UPDATED_DT | date |
  2051. | NAME | varchar(50) |
  2052. | NATIONALITY | varchar(50) |
  2053. | PASSWORD | varchar(32) |
  2054. | PHONE | varchar(50) |
  2055. | PROFESSIONAL | varchar(100) |
  2056. | SEX | varchar(6) |
  2057. | STATE | varchar(50) |
  2058. | USER_ID | varchar(30) |
  2059. +--------------------+--------------+
  2060.  
  2061. Database: 371894_IC
  2062. Table: WD_ADDRESS_BK
  2063. [18 columns]
  2064. +-----------------+--------------+
  2065. | Column | Type |
  2066. +-----------------+--------------+
  2067. | ADDRESS_LN1 | varchar(100) |
  2068. | ADDRESS_LN2 | varchar(100) |
  2069. | ADDRESS_TYPE | varchar(50) |
  2070. | CITY | varchar(50) |
  2071. | COMPANY_NAME | varchar(100) |
  2072. | CREATE_DT | timestamp |
  2073. | CREATED_BY | varchar(20) |
  2074. | EMAIL_ID | varchar(100) |
  2075. | FAX | varchar(50) |
  2076. | LAST_UPDATED_BY | varchar(20) |
  2077. | LAST_UPDATED_DT | timestamp |
  2078. | PHONE | varchar(100) |
  2079. | POSTAL_CD | varchar(10) |
  2080. | SOURCE_URL | varchar(100) |
  2081. | STATE_ID | varchar(10) |
  2082. | WD_ADDRESS_ID | int(11) |
  2083. | WD_COMPANY_NAME | varchar(100) |
  2084. | WD_LISTING_ID | int(11) |
  2085. +-----------------+--------------+
  2086.  
  2087. Database: 371894_IC
  2088. Table: IC_JEWEL_CATEGORIES
  2089. [7 columns]
  2090. +-----------+-------------+
  2091. | Column | Type |
  2092. +-----------+-------------+
  2093. | CAT_ID | smallint(6) |
  2094. | CAT_NM | varchar(40) |
  2095. | CITY_ID | smallint(6) |
  2096. | CITY_NM | varchar(40) |
  2097. | FILE_NM | varchar(30) |
  2098. | FOLDER_NM | varchar(30) |
  2099. | REC_COUNT | smallint(6) |
  2100. +-----------+-------------+
  2101.  
  2102. Database: 371894_IC
  2103. Table: IC_ADD_A_BUSINESS_LISTINGS
  2104. [25 columns]
  2105. +------------------+--------------+
  2106. | Column | Type |
  2107. +------------------+--------------+
  2108. | ADDR1 | varchar(100) |
  2109. | ADDR2 | varchar(100) |
  2110. | BUSINESS_NM | varchar(100) |
  2111. | CAT_ID | smallint(6) |
  2112. | CAT_NM | varchar(50) |
  2113. | CITY_ID | smallint(6) |
  2114. | CITY_NM | varchar(50) |
  2115. | CREATE_DT | datetime |
  2116. | DIRECTORY_ID | smallint(6) |
  2117. | EMAIL_ID | varchar(200) |
  2118. | FAX | varchar(50) |
  2119. | LAST_UPDT_DT | datetime |
  2120. | LISTING_ID | int(11) |
  2121. | LOCALITY | varchar(100) |
  2122. | LOGO_URL | varchar(100) |
  2123. | MOBILE | varchar(50) |
  2124. | PHONE | varchar(50) |
  2125. | PINCODE | varchar(10) |
  2126. | STATUS | varchar(2) |
  2127. | UNIQUE_CODE | varchar(30) |
  2128. | USER_DESIGNATION | varchar(50) |
  2129. | USER_EMAIL_ID | varchar(100) |
  2130. | USER_MOBILE | varchar(50) |
  2131. | USER_NAME | varchar(100) |
  2132. | WEBSITE_URL | varchar(200) |
  2133. +------------------+--------------+
  2134.  
  2135. Database: 371894_IC
  2136. Table: IC_BUILDING_MATERIALS_TYPE
  2137. [2 columns]
  2138. +-------------+--------------+
  2139. | Column | Type |
  2140. +-------------+--------------+
  2141. | CATEGORY | varchar(100) |
  2142. | CATEGORY_ID | smallint(6) |
  2143. +-------------+--------------+
  2144.  
  2145. Database: 371894_IC
  2146. Table: WD_LOGOS
  2147. [3 columns]
  2148. +-----------------+--------------+
  2149. | Column | Type |
  2150. +-----------------+--------------+
  2151. | CREATE_DT | timestamp |
  2152. | LOGO_FILENAME | varchar(100) |
  2153. | WD_COMPANY_NAME | varchar(100) |
  2154. +-----------------+--------------+
  2155.  
  2156. Database: 371894_IC
  2157. Table: EMAIL_LIST
  2158. [7 columns]
  2159. +---------------+--------------+
  2160. | Column | Type |
  2161. +---------------+--------------+
  2162. | CITY | varchar(50) |
  2163. | DT | date |
  2164. | EMAIL | varchar(255) |
  2165. | REFERRAL_CODE | varchar(20) |
  2166. | SNO | int(11) |
  2167. | SOURCE | varchar(50) |
  2168. | UNSUBSCRIBED | varchar(5) |
  2169. +---------------+--------------+
  2170.  
  2171. Database: 371894_IC
  2172. Table: IC_NEWS_SOURCE
  2173. [2 columns]
  2174. +----------------+--------------+
  2175. | Column | Type |
  2176. +----------------+--------------+
  2177. | NEWS_SOURCE_ID | smallint(6) |
  2178. | SOURCE_NM | varchar(100) |
  2179. +----------------+--------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!