TEST

Tables (20)

alarm_preference

  • member_id — BIGINT
  • sos_preference — TINYINT(1)
  • announce_preference — TINYINT(1)
  • alarm_start_time — TIME
  • alarm_end_time — TIME

announce

  • 공고 항목 분류 (announce_id) — BigInt
  • 공고명 (announce_title) — VARCHAR(255)
  • 공고 URL (link) — VARCHAR(2048)
  • 소관명 (author) — VARCHAR(100)
  • 수행기관명 (exc_instt_nm) — VARCHAR(100)
  • 사업개요내용 (description) — TEXT
  • 지원분야대분류명 (lcategory) — VARCHAR(50)
  • 등록일자 (pub_date) — DATE
  • 신청기간 (reqst_date) — VARCHAR(100)
  • 지원대상 (taget_name) — VARCHAR(100)
  • 조회수 (view_num) — INT
  • 본문출력파일경로명 (file_path_name) — VARCHAR(1024)
  • 본문출력파일명 (file_name) — VARCHAR(255)
  • 해시태그 (hashtags) — VARCHAR(500)
  • 사업신청방법내용 (how_to_register) — VARCHAR(500)
  • 문의처 (call_company) — VARCHAR(255)

articles

  • article_id — CHAR(36)
  • title — VARCHAR(255)
  • content — TEXT
  • category — VARCHAR(100)
  • author — VARCHAR(100)
  • published_at — DATETIME
  • article_url — VARCHAR(2048)

auth

  • member_auth_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • auth — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL

chat_message

  • chat_message_id — BIGINT
  • chat_room_id — BIGINT — NOT NULL
  • sender_id — BIGINT
  • content — TEXT
  • created_at — TIMESTAMP — NOT NULL

chat_participant

  • chat_participant_id — BIGINT
  • chat_room_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

chat_room

  • chat_room_id — BIGINT
  • sos_id — BIGINT
  • name — VARCHAR(255)
  • is_active — TINYINT(1)
  • is_group — TINYINT(1)

document

  • document_id — BIGINT
  • announce_id — VARCHAR(40) — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT

festival

  • festival_id — VARCHAR(60)
  • addr1 — VARCHAR(255)
  • addr2 — VARCHAR(255)
  • event_startdate — DATE
  • event_enddate — DATE
  • first_image — VARCHAR(1024)
  • tel — VARCHAR(50)
  • festival_title — VARCHAR(255)
  • overview — TEXT
  • content_id — VARCHAR(60)

image

  • image_id — BIGINT
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

industry

  • industry_id — BIGINT
  • major_code — VARCHAR(50)
  • major_name — VARCHAR(100)
  • middle_code — VARCHAR(50)
  • middle_name — VARCHAR(100)
  • minor_code — VARCHAR(50)
  • minor_name — VARCHAR(100)

member

  • member_id — BIGINT
  • industry_id — BIGINT
  • region_id — BIGINT
  • image_id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • member_name — VARCHAR(100)
  • address — VARCHAR(255)
  • address_detail — VARCHAR(255)
  • kakao_id — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • status — ENUM('active','suspended','deleted')
  • fcm_token — VARCHAR(255)

member_document_check

  • user_document_check_id — BIGINT
  • document_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • status — TINYINT(1)
  • checked_at — DATETIME

message_read_status

  • message_read_status_id — BIGINT
  • chat_message_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • read_at — TIMESTAMP

notice

  • notice_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notification

  • notification_id — BIGINT
  • title — VARCHAR(255)
  • content — TEXT
  • noti_type — ENUM('all','notice','sos','announce','festival')
  • is_read — TINYINT(1)
  • created_at — DATETIME

region

  • region_id — BIGINT
  • si — VARCHAR(50)
  • sigungu — VARCHAR(100)
  • eupmyeon_dong — VARCHAR(100)

sos

  • sos_id — BIGINT
  • store_name — VARCHAR(255) — NOT NULL
  • sos_type — ENUM('stock','labor','equipment','etc') — NOT NULL
  • sos_content — TEXT — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • priority — ENUM('low','normal','high') — NOT NULL
  • created_at — DATETIME — NOT NULL

sos_image

  • sos_image_id — BIGINT
  • sos_id — BIGINT — NOT NULL
  • image_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_favorite

  • favorite_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • target_type — ENUM('festival','announce') — NOT NULL
  • target_id — VARCHAR(60) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL