msbuildweather
Tables (7)
ADJECTIVE_TB
- ADJECTIVE_ID — bigint — Primary key — NOT NULL
- WORD — varchar(45)
ADVERB_TB
- ADVERB_ID — bigint — Primary key — NOT NULL
- WORD — varchar(45)
EMOJI_TB
- EMOJI_ID — bigint — Primary key — NOT NULL
- EMOJI_NAME — varchar(45)
- EMOJI — varchar(45)
MEMBER_REGION_MAPPING_TB
- SEQ — bigint — Primary key — NOT NULL
- STATUS — varchar(255) — NOT NULL
- MEMBER_ID — bigint — Foreign key → MEMBER_TB.MEMBER_ID — NOT NULL
- REGION_ID — bigint — Foreign key → REGION_TB.REGION_ID — NOT NULL
MEMBER_TB
- MEMBER_ID — bigint — Primary key — NOT NULL
- CREATED_DATE — datetime(6)
- MODIFIED_DATE — datetime(6)
- NICKNAME — varchar(255)
- SOCIAL_ID — varchar(255) — NOT NULL
- SOCIAL_TYPE — varchar(255) — NOT NULL
- MEMBER_EMOJI — varchar(45) — NOT NULL
REGION_TB
- REGION_ID — bigint — Primary key — NOT NULL
- BIGSCALE — varchar(45)
- MIDSCALE — varchar(45)
- SMALLSCALE — varchar(45)
- LOCATION_X — int
- LOCATION_Y — int
SURVERY_TB (Untitled)
- SURVEY_ID (suerveyId) — Primary key — NOT NULL
- Question (question) — varchar(80)
- Field