MiniSns

Tables (6)

IB_BORDER (Untitled)

  • IDX — INT(11) — Primary key — NOT NULL — 인덱스
  • FILE (Key) — BIGINT(20) — Foreign key → IB_FILE_MASTER.id — NOT NULL
  • IB_USER_KAKAO_USERID (Key2) — VARCHAR(50) — Foreign key → IB_USER.KAKAO_USERID — NOT NULL
  • CONTENTS (Field) — VARCHAR(200)
  • IMG_URL (Field2) — VARCHAR(1)
  • IMG_THUMNAIL (Field3) — VARCHAR(1)
  • REG_DATE (Field4) — TIMESTAMP

IB_FAV (Untitled2)

  • IDX (Key) — INT(11) — Primary key — NOT NULL
  • IB_BORDER_IDX (IDX) — INT — Foreign key → IB_BORDER.IDX — NOT NULL — 인덱스
  • IB_USER_KAKAO_USERID (Key3) — VARCHAR(50) — Foreign key → IB_USER.KAKAO_USERID — NOT NULL
  • REG_DATE (Field) — DATETIME

IB_FILE (Untitled3)

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • IB_FILE_MASTER_id (Key2) — BIGINT(20) — Foreign key → IB_FILE_MASTER.id — NOT NULL
  • REG_DATE (Field) — DATETIME
  • file_name (Field2) — VARCHAR(100)
  • original_filename (Field3) — VARCHAR(100)
  • size (Field4) — BIGINT(20)
  • type (Field5) — VARCHAR(20)

IB_FILE_MASTER (Untitled4)

  • id (Key) — BIGINT(20) — Primary key — NOT NULL
  • REG_DATE (Field) — DATETIME
  • cname (Field2) — VARCHAR(255)
  • ctype (Field3) — VARCHAR(255)
  • pid (Field4)

IB_REPLY (Untitled5)

  • IDX (Key) — INT(11) — Primary key — NOT NULL
  • IB_BORDER_IDX (IDX) — INT(11) — Foreign key → IB_BORDER.IDX — NOT NULL — 인덱스
  • IB_USER_KAKAO_USERID (Key3) — VARCHAR(50) — Foreign key → IB_USER.KAKAO_USERID — NOT NULL
  • CONTENT (Field) — VARCHAR(200)
  • REG_DATE (Field2) — DATETIME

IB_USER (Untitled6)

  • KAKAO_USERID (Key) — VARCHAR(50) — Primary key — NOT NULL
  • KAKAO_EMAIL (Field) — VARCHAR(50)
  • KAKAO_PRF_URL (Field2) — VARCHAR(200)
  • KAKAO_ACCESS_TOKEN (Field3) — VARCHAR(100)
  • DEVICE_ID (Field4) — VARCHAR(100)
  • NICK_NAME (Field5) — VARCHAR(50)
  • FCM_TOKEN (Field6) — VARCHAR(200)
  • FCM_USE_YN (Field7) — VARCHAR(5)
  • REG_DATE (Field8)