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)