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)