wepin2
Tables (22)
BAN
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- BAN_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
BLACKLIST
- ID — varchar(40) — NOT NULL
- MEMBER_ID — varchar(100) — NOT NULL
- REASON — varchar(100)
- REASON_DETAIL — varchar(1000)
- STATUS — varchar(100) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- BLACK_ID — varchar(40) — NOT NULL
- FEED_ID — varchar(40)
CODE
- ID — varchar(40) — Primary key — NOT NULL
- CD_CLS_ID — varchar(100) — NOT NULL
- CD_ID — varchar(100) — NOT NULL
- CD_NM — varchar(100)
- DESCRIPTION — varchar(100)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
CODE_CLASS
- ID — varchar(40) — Primary key — NOT NULL
- CD_CLS_ID — varchar(100) — NOT NULL
- CD_CLS_NM — varchar(100)
- DESCRIPTION — varchar(100)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
CUSTOM_PIN
- ID — varchar(40) — Primary key — NOT NULL
- NAME — varchar(40)
- MAIN_URL — varchar(4000)
- SUB_URL — varchar(4000)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- DESCRIPTION — varchar(400)
- TYPE — varchar(40)
FEED
- FEED_ID — varchar(40) — Primary key — NOT NULL
- TITLE — varchar(100) — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- SHARE_URL — varchar(100)
- DESCRIPTION — varchar(400)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- IMG_URL — varchar(1000)
- ZOOM_LEVEL — int(11)
- CUSTOM_PIN_ID — varchar(40)
FEED_PIN
- ID — varchar(40) — Primary key — NOT NULL
- FEED_ID — varchar(40) — NOT NULL
- PIN_ID — varchar(40) — NOT NULL
- UI_SEQ — int(11)
- IS_MAIN — bit(1)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
FEED_TAG
- ID — varchar(40) — Primary key — NOT NULL
- FEED_ID — varchar(40) — NOT NULL
- TAG_ID — varchar(40) — NOT NULL
- UI_SEQ — int(11)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
FOLLOW
- ID — varchar(40) — Primary key — NOT NULL
- FOLLOWER_ID — varchar(40) — NOT NULL
- FOLLOWING_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
HIDE
- ID — varchar(40) — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- FEED_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
IMAGE
- ID — varchar(40) — Primary key — NOT NULL
- PIN_ID — varchar(40) — NOT NULL
- IMAGE — varchar(4000)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- UI_SEQ — int(11)
LIKES
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- FEED_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
LOG
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40)
- NAME — varchar(100)
- TYPE — varchar(40)
- LOC — varchar(400)
- MESSAGE — longtext
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
MEMBER
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(100) — NOT NULL
- PASSWORD — varchar(100)
- NAME — varchar(100)
- EMAIL — varchar(100)
- NICKNAME — varchar(100) — NOT NULL
- PROFILE — varchar(1000) — 프로필 이미지
- TYPE — varchar(100) — 가입 유형
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- INTRODUCE — varchar(1000)
- AUTH — varchar(10)
MEMBER_CURRENT_PIN
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- CUSTOM_PIN_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
MEMBER_CUSTOM_PIN
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- CUSTOM_PIN_ID — varchar(40) — NOT NULL
- END_AT — datetime
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
PIN
- PIN_ID — varchar(40) — Primary key — NOT NULL
- ADDRESS — varchar(100) — NOT NULL
- LATITUDE — varchar(40) — NOT NULL
- LONGITUDE — varchar(40) — NOT NULL
- IS_MAIN — bit(1)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- UI_SEQ — int(11)
- NAME — varchar(40)
- ADDRESS_DETAIL — varchar(100)
- ADDRESS_STREET — varchar(100)
PUSH
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- IS_ALL_ACTIVATED — bit(1)
- IS_LIKE_ACTIVATED — bit(1)
- IS_FEED_ACTIVATED — bit(1)
- IS_REPLY_ACTIVATED — bit(1)
- IS_FOLLOW_ACTIVATED — bit(1)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
PUSH_HISTORY
- ID — varchar(40) — Primary key — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- REF_ID — varchar(40) — NOT NULL
- TYPE — varchar(40)
- MESSAGE — longtext
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- SENDER_ID — varchar(40) — NOT NULL
REPLY
- ID — varchar(40) — Primary key — NOT NULL
- FEED_ID — varchar(40) — NOT NULL
- PARENT_ID — varchar(40)
- DESCRIPTION — varchar(40) — NOT NULL
- IS_LIKE — bit(1)
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- UI_SEQ — int(11)
- MEMBER_ID — varchar(40) — NOT NULL
TAG
- ID — varchar(40) — Primary key — NOT NULL
- TAG_NAME — varchar(100) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)
- USED_CNT — int(11)
TOKEN
- ID — varchar(40) — Primary key — NOT NULL
- TOKEN — longtext — NOT NULL
- MEMBER_ID — varchar(40) — NOT NULL
- IS_ACTIVATED — bit(1)
- IS_DELETED — bit(1)
- CREATED_AT — datetime
- CREATED_BY — varchar(100)
- UPDATED_AT — datetime
- UPDATED_BY — varchar(100)