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