<table name="ncenterlite_notify">
	<column name="id" type="bignumber" notnull="notnull" primary_key="primary_key" auto_increment="auto_increment" brief="Separate PK column for performance optimization" />
	<column name="notify" type="char" size="32" notnull="notnull" unique="unique_notify" brief="메시지 ID" />
	<column name="srl" type="number" notnull="notnull" index="idx_srl" brief="이벤트 대상의 상위 srl" />
	<column name="target_srl" type="number" notnull="notnull" index="idx_target_srl" brief="이벤트 대상 srl(문서/댓글)" />
	<column name="target_p_srl" type="number" notnull="notnull" index="idx_target_p_srl" brief="이벤트 대상 srl(문서/댓글) 대댓글의 경우 앞전 댓글" />
	<column name="type" type="char" size="1" notnull="notnull" brief="이벤트 대상 타입" />
	<column name="target_type" type="char" size="1" notnull="notnull" brief="이벤트 타입" />
    <column name="notify_type" type="number" brief="이벤트 타입 SRL" />
	<column name="member_srl" type="number" notnull="notnull" index="idx_member_srl" brief="receiver" />
	<column name="target_member_srl" type="number" notnull="notnull" index="idx_target_member_srl" brief="sender" />
	<column name="target_nick_name" type="varchar" size="80" notnull="notnull" brief="sender" />
	<column name="target_user_id" type="varchar" size="80" notnull="notnull" brief="sender" />
	<column name="target_email_address" type="varchar" size="80" notnull="notnull" brief="sender" />
	<column name="target_browser" type="varchar" size="80" brief="브라우저 제목" />
	<column name="target_summary" type="varchar" size="80" brief="메시지 요약문" />
	<column name="target_body" type="varchar" size="255" brief="커스텀 알림 제목" />
	<column name="target_url" type="varchar" size="255" notnull="notnull" brief="링크 목적지 주소" />
	<column name="data" type="longtext" />
	<column name="readed" type="char" size="1" default="N" notnull="notnull" index="idx_readed" />
	<column name="regdate" type="date" index="idx_regdate" />
</table>
