TTA 플랫폼 for 연구소 - generated

테이블 (33)

NF

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • notice_uuid — BINARY(16) — 외래 키 → n.uuid
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • name — VARCHAR(256) — NOT NULL
  • mime — VARCHAR(255) — NOT NULL
  • url — VARCHAR(128) — NOT NULL
  • s3_bucket — VARCHAR(128) — NOT NULL
  • s3_key — VARCHAR(128) — NOT NULL

PT_P

  • id — BIGINT — 기본 키 — NOT NULL
  • poi_version_uuid — binary(16) — 외래 키 → PT_V.uuid — NOT NULL
  • drawingId — INT
  • drawingName — VARCHAR(30)
  • drawingCode — VARCHAR(10)
  • floorId — INT
  • floorName — VARCHAR(30)
  • code — VARCHAR(30)
  • nameKo — VARCHAR(30)
  • nameEn — VARCHAR(30)
  • nameJa — VARCHAR(30)
  • nameZh — VARCHAR(30)
  • subTitleKo — VARCHAR(30)
  • subTitleEn — VARCHAR(30)
  • subTitleJa — VARCHAR(30)
  • subTitleZh — VARCHAR(30)
  • notice — VARCHAR(30)
  • x — DECIMAL
  • y — DECIMAL
  • z — DECIMAL
  • lon — DECIMAL
  • lat — DECIMAL
  • updDt — VARCHAR(50)
  • dtype — VARCHAR(50)

PT_T

  • id — INTEGER — 기본 키 — NOT NULL
  • poi_version_uuid — binary(16) — 외래 키 → PT_V.uuid — NOT NULL
  • drawingId — INT
  • drawingCode — VARCHAR(10)
  • drawingName — VARCHAR(30)
  • categoryName — VARCHAR(30)
  • topologyData — TEXT
  • updDt — VARCHAR(30)
  • topoJson — JSON
  • mapNo — INT
  • mapNm — VARCHAR(100)

PT_V

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • id — int — NOT NULL
  • created_at — DATETIME
  • sha512 — VARCHAR(128)
  • comment — TEXT

a

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • question_uuid — BINARY(16) — 외래 키 → q.uuid — NOT NULL
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • text — TEXT

auth_log

  • id — BIGINT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • ip — VARCHAR(45) — NOT NULL
  • user_agent — VARCHAR(200)
  • os — VARCHAR(50)
  • username — VARCHAR(50)
  • application_version — VARCHAR(10)
  • target — VARCHAR(30)

auth_log_geo

  • id — BIGINT — 외래 키 → auth_log.id — NOT NULL
  • country — VARCHAR(10)
  • code — VARCHAR(10)
  • r1 — VARCHAR(30)
  • r2 — VARCHAR(30)
  • r3 — VARCHAR(30)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • network — VARCHAR(10)

evt

  • id — BIGINT — 기본 키 — NOT NULL
  • beacon_uuid — BINARY(16) — 외래 키 → stat.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • title — VARCHAR — NOT NULL

evt_comment

  • id — BIGINT — NOT NULL
  • beacon_uuid — BINARY(16) — 외래 키 → stat.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • voltage_mv — INT — NOT NULL

evt_extra

  • id — BIGINT — 기본 키 — NOT NULL
  • beacon_uuid — BINARY(16) — 외래 키 → stat.uuid — NOT NULL
  • id2 — BIGINT — 외래 키 → evt.id — NOT NULL
  • beacon_uuid2 — BINARY(16) — 외래 키 → evt.beacon_uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • user_uuid2 — BINARY(16) — 외래 키 → evt.user_uuid
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • extra1 — VARCHAR — NOT NULL
  • extra2 — VARCHAR
  • extra3 — VARCHAR
  • extra4 — VARCHAR
  • extra5 — VARCHAR
  • extra6 — VARCHAR
  • extra7 — VARCHAR
  • extra8 — VARCHAR
  • extra9 — VARCHAR

f_log

  • id — BIGINT — 기본 키 — NOT NULL
  • created_at — DATETIME — NOT NULL
  • data — JSON

n

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • title — VARCHAR(30) — NOT NULL
  • content — VARCHAR(50000) — NOT NULL

n_t

  • id — INT — 기본 키 — NOT NULL
  • notice_uuid — BINARY(16) — 외래 키 → n.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • url — VARCHAR(128) — NOT NULL
  • s3_bucket — VARCHAR(128) — NOT NULL
  • s3_key — VARCHAR(128) — NOT NULL

nf

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • category — VARCHAR(50) — NOT NULL
  • url — VARCHAR(128)
  • title — VARCHAR(100) — NOT NULL
  • text — VARCHAR(1000)
  • read — TINYINT(1) — NOT NULL

nl

  • id — BIGINT — 기본 키 — NOT NULL
  • notice_uuid — BINARY(16) — 외래 키 → n.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid

nv_log

  • id — BIGINT — 기본 키 — NOT NULL
  • notice_uuid — BINARY(16) — 외래 키 → n.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL

q

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • text — TEXT — NOT NULL

q_f

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • question_uuid — BINARY(16) — 외래 키 → q.uuid — NOT NULL
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • name — VARCHAR(100) — NOT NULL
  • mime — VARCHAR(128)
  • url — VARCHAR(2048) — NOT NULL
  • s3_bucket — VARCHAR(100)
  • s3_key — VARCHAR(1024)

s_eva_log

  • id — INT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL

s_log

  • id — BIGINT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • text — VARCHAR(50) — NOT NULL
  • latitude — DECIMAL(11,8)
  • longitude — DECIMAL(11,8)

slv

  • uuid — binary(16) — 기본 키 — NOT NULL
  • id — INT — NOT NULL
  • url — VARCHAR(2048) — NOT NULL
  • mime — VARCHAR(128) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • s3_key — VARCHAR(128) — NOT NULL
  • s3_bucket — VARCHAR(128) — NOT NULL

stat

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • id — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • deleted_at — DATETIME
  • status — ENUM

tt_ts

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • version_uuid — BINARY(16) — 외래 키 → tt_v.uuid — NOT NULL
  • id — INT — NOT NULL
  • UC_SEQ — INT
  • MAIN_TITLE — VARCHAR(128)
  • GUGUN_NAME — VARCHAR(128)
  • CATE2_NM — VARCHAR(128)
  • LAT — DECIMAL(11,7)
  • LNG — DECIMAL(11,7)
  • PLACE — VARCHAR(128)
  • TITLE — VARCHAR(128)
  • SUBTITLE — VARCHAR(128)
  • MAIN_PLACE — VARCHAR(128)
  • ADDR1 — VARCHAR(1000)
  • ADDR2 — VARCHAR(1000)
  • CNTCT_TEL — VARCHAR(15)
  • HOMEPAGE_URL — VARCHAR(128)
  • TRFC_INFO — VARCHAR(1000)
  • USAGE_DAY — VARCHAR(1000)
  • HLDY_INFO — VARCHAR(1000)
  • USAGE_DAY_WEEK_AND_TIME — VARCHAR(1000)
  • USAGE_PRICE — VARCHAR(128)
  • MIDDLE_SIZE_RM1 — VARCHAR(128)
  • MAIN_IMG_NORMAL — VARCHAR(2048)
  • MAIN_IMG_THUMB — VARCHAR(2048)
  • ITEMCNTNTS — TEXT

tt_ts_log

  • tourist_spot_uuid — BINARY(16) — 외래 키 → tt_ts.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

tt_v

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • sha512 — VARCHAR(128)
  • comment — VARCHAR(1000)

tt_v_log

  • version_uuid — BINARY(16) — 외래 키 → tt_v.uuid — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

u

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • id — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • username — VARCHAR(36) — NOT NULL
  • password — CHAR(60) — NOT NULL
  • type — ENUM('ADMIN', 'STAFF', 'NORMAL') — NOT NULL

u_c_log

  • id — INT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • category_uuid — BINARY(16) — 외래 키 → uc.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL

u_l_log

  • id — BIGINT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL
  • androidId — VARCHAR(64)
  • buildId — VARCHAR(64)
  • buildIdNumber — VARCHAR(64)
  • brand — VARCHAR(64)
  • carrier — VARCHAR(64)
  • deviceId — VARCHAR(64)
  • deviceType — VARCHAR(64)
  • deviceName — VARCHAR(64)
  • installerPackageName — VARCHAR(64)
  • referer — VARCHAR(64)
  • manufacturer — VARCHAR(64)
  • model — VARCHAR(64)
  • uniqueId — VARCHAR(64)
  • version — VARCHAR(64)

uc

  • uuid — BINARY(16) — 기본 키 — NOT NULL
  • id — INT — NOT NULL
  • nameKo — VARCHAR(50) — NOT NULL
  • nameJa — VARCHAR(50)
  • nameZh — VARCHAR(50)
  • nameEn — VARCHAR(50)
  • iconUrl — VARCHAR(2048)

uft

  • id — BIGINT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • expired_at — DATETIME
  • token — CHAR(163) — NOT NULL
  • token_hash_sha_256 — CHAR(64) — NOT NULL

ut

  • id — bigint — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid — NOT NULL
  • created_at — DATETIME — NOT NULL
  • expired_at — DATETIME
  • hash — VARCHAR(128)
  • Token — VARCHAR(1000)

v_l

  • id — BIGINT — 기본 키 — NOT NULL
  • user_uuid — BINARY(16) — 외래 키 → u.uuid
  • created_at — DATETIME — NOT NULL
  • text — VARCHAR(50) — NOT NULL