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