테이블 명세서
테이블 (18)
ACHIEVEMENT
- ID — bigint
- TITLE — varchar(255) — NOT NULL
- DESCRIPTION — varchar(500)
- ICON — varchar(50)
- RARITY — enum
- TARGET — int
- GOAL_VALUE — double — NOT NULL
- UNIT — varchar(50)
- CREATED_AT — datetime
BIKE_ROUTE
- ROUTE_ID — bigint
- NAME — varchar(200) — NOT NULL
- DIST_KM — decimal(8, 2) — NOT NULL
- DURATION_MIN — int — NOT NULL
- FILE_NAME — varchar(255)
- CREATED_AT — datetime — NOT NULL
BIKE_ROUTE_POINT
- POINT_ID — bigint
- ROUTE_ID — bigint — NOT NULL
- SEQ — int — NOT NULL
- LAT — decimal(10, 7) — NOT NULL
- LNG — decimal(10, 7) — NOT NULL
- ELEV_M — decimal(7, 2)
- CREATED_AT — datetime — NOT NULL
CHALLENGE
- ID — bigint
- TITLE — varchar(255) — NOT NULL
- DESCRIPTION — varchar(500)
- GOAL_VALUE — double — NOT NULL
- UNIT — varchar(50)
- PERIOD_TYPE — enum
- CREATED_AT — datetime
COMMUNITY
- USER_ID — varchar(100)
- CONTENTS — varchar(4000)
- LIKES — int
- CHG_DT — datetime
- COMMUNITY_ID — bigint
- LIKED — tinyint(1)
COMMUNITY_COMMENT
- COMMUNITY_ID); — ( COMMENT_ID bigint auto_increment primary key COMMUNITY_ID bigint not null — NOT NULL
- USER_ID — varchar(100) — NOT NULL
- CONTENTS — text — NOT NULL
- CHG_DT — datetime — NOT NULL
COMMUNITY_LIKE
- COMMUNITY_ID — varchar(50) — 기본 키 — NOT NULL
- USER_ID — varchar(100) — 기본 키 — NOT NULL
- CREATED_AT — datetime — NOT NULL
EVENT_EXCHANGE
- ID — bigint
- USER_ID — varchar(100) — NOT NULL
- ITEM_ID — bigint — NOT NULL
- QTY — int — NOT NULL
- USED_POINTS — int — NOT NULL
- EXCHANGED_AT — datetime
EVENT_REWARD_ITEM
- ID — bigint
- NAME — varchar(100) — NOT NULL
- DESCRIPTION — mediumtext
- POINTS_COST — int — NOT NULL
- CATEGORY — varchar(50)
- IMAGE — varchar(255)
- STOCK — int — NOT NULL
- POPULAR — tinyint(1)
- TIME_LIMIT — datetime
- CREATED_AT — datetime
GROUP_RIDE
- ID — bigint
- TITLE — varchar(255) — NOT NULL
- ORGANIZER_ID — varchar(100) — NOT NULL
- ORGANIZER_NAME — varchar(100) — NOT NULL
- DATE — date — NOT NULL
- TIME — time — NOT NULL
- LOCATION — varchar(255) — NOT NULL
- DISTANCE — float — NOT NULL
- MAX_PARTICIPANTS — int — NOT NULL
- DIFFICULTY — varchar(20) — NOT NULL
- CREATED_AT — datetime
GROUP_RIDE_JOIN
- ID — bigint
- GROUP_RIDE_ID — bigint — NOT NULL
- USER_ID — varchar(100) — NOT NULL
- JOINED_AT — datetime
MAIL_INFO
- MAIL_SEQ — int
- TITLE — varchar(100)
- CONTENTS — varchar(4000)
- TOMAIL — varchar(100)
- CHG_DT — datetime
NOTICE
- NOTICE_SEQ — int
- TITLE — varchar(1000)
- CONTENTS — varchar(4000)
- NOTICE_YN — varchar(100)
- READ_CNT — int
- USER_ID — varchar(100)
- REG_ID — varchar(100)
- REG_DT — datetime
- CHG_ID — varchar(100)
- CHG_DT — datetime
- IMAGE_PATH — varchar(1000)
USER_ACHIEVEMENT
- ID — bigint
- USER_ID — varchar(100) — NOT NULL
- ACHIEVEMENT_ID — bigint — NOT NULL
- PROGRESS — int
- TARGET — int
- ACHIEVED_AT — datetime
USER_CHALLENGE
- ID — bigint
- USER_ID — varchar(100) — NOT NULL
- CHALLENGE_ID — bigint — NOT NULL
- PROGRESS_VALUE — double
- COMPLETED — tinyint(1)
USER_INFO
- USER_ID — varchar(100) — NOT NULL
- USER_NAME — varchar(100)
- PASSWORD — varchar(100)
- EMAIL — varchar(100)
- PROFILE_IMAGE — varchar(255)
- ADDR1 — varchar(4000)
- ADDR2 — varchar(4000)
- ROLES — varchar(100)
- REG_ID — varchar(100)
- REG_DT — datetime
- CHG_ID — varchar(100)
- CHG_DT — datetime
USER_RANK
- ID — bigint
- USER_ID — varchar(100) — NOT NULL
- USER_NAME — varchar(100) — NOT NULL
- POINTS — int
- DISTANCE — float
- CREATED_AT — datetime
- CARBON_SAVED — double
- AVATAR — varchar(50)
- LEVEL — int
- ACHIEVEMENTS — int
- CHALLENGES — int
warn_spot
- id — bigint
- spot_nm — varchar(200) — NOT NULL
- occrrnc_cnt — int
- caslt_cnt — int
- dth_dnv_cnt — int
- se_dnv_cnt — int
- sl_dnv_cnt — int
- lo_crd — decimal(10, 6)
- la_crd — decimal(10, 6)
- geom_json — longtext
- src_hash — char(64) — NOT NULL
- updated_at — timestamp — NOT NULL