foodinko
Tables (50)
comm_cadr_area
- seq — BIGINT — Primary key — NOT NULL
- cadr_cd — VARCHAR(10) — NOT NULL
- cadr_fg — INT — NOT NULL — 1: 시도 2: 시군구 3: 읍면동
- sido_cd — VARCHAR(10) — NOT NULL
- sigungu_cd — VARCHAR(10)
- dong_cd — VARCHAR(10)
- sido_nm — VARCHAR(30) — NOT NULL
- sigungu_nm — VARCHAR(40)
- dong_nm — VARCHAR(30)
- cadr_nm — VARCHAR(100) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- reg_dttm — DATETIME — NOT NULL
- updt_dttm — DATETIME — NOT NULL
- reg_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updt_user_seq — BIGINT — Foreign key → tb_user.seq
comm_file
- seq — BIGINT — Primary key — NOT NULL
- file_group — VARCHAR(36) — NOT NULL — 해쉬 64byte 문서 하나에 여러 파일 등록
- file_div — BIGINT — NOT NULL — 1: 사용자 프로파일 2: 피드 사진 3: 피드 동영상 4: 댓글 사진
- save_nm — VARCHAR(48) — NOT NULL
- origin_nm — VARCHAR(255) — NOT NULL
- path — VARCHAR(128) — NOT NULL
- size — BIGINT — NOT NULL
- ext — VARCHAR(8) — NOT NULL
- mime_type — VARCHAR(255)
- file_ord — INT — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- reg_dttm — DATETIME — NOT NULL
- updt_dttm — DATETIME
- has_webp — TINYINT — NOT NULL
- reg_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updt_user_seq — BIGINT — Foreign key → tb_user.seq
comm_mail
- seq — BIGINT — Primary key — NOT NULL
- mail_div — BIGINT — NOT NULL — 의견 답변 메일 ,메일 발송 업무에 따라 추가 가능
- mail_grp — VARCHAR(36) — NOT NULL — 해시 36 byte 문서 하나에 여러 메일 등록
- send_mail — VARCHAR(254) — NOT NULL
- recp_mail — VARCHAR(254) — NOT NULL
- mail_ttl — VARCHAR(250)
- mail_ctnt — VARCHAR(4000)
- mail_file_grp — VARCHAR(36)
- send_st_div — BIGINT — NOT NULL — 1: 발송 준비 2: 오류 3: 성공
- error_resn — VARCHAR(1000)
- reg_dttm — DATETIME — NOT NULL
- updt_dttm — DATETIME
- reg_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updt_user_seq — BIGINT — Foreign key → tb_user.seq
ctnt_opin
- seq — BIGINT — Primary key — NOT NULL
- opin_ctnt — VARCHAR(4000) — NOT NULL
- repl_email — VARCHAR(254)
- repl_mthd_div — BIGINT — NOT NULL — 1: 메일 2: 답변 없음 향후 기획안에 따라 추가 가능
- repl_mail_grp — VARCHAR(36)
- tret_st_div — BIGINT — NOT NULL — 1: 요청 2: 접수 3: 발송 4: 재발송
- re_send_resn — VARCHAR(1000)
- repl_dttm — DATETIME
- reg_dttm — DATETIME — NOT NULL
- updt_dttm — DATETIME
- repl_user_seq — BIGINT — Foreign key → tb_user.seq
- reg_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updt_user_seq — BIGINT — Foreign key → tb_user.seq
ctnt_recomd_pl
- seq — BIGINT — Primary key — NOT NULL
- loc_info — GEOMETRY — NOT NULL — 지도상 가운데 위치
- tret_st_div — BIGINT — NOT NULL — 1: 요청 2: 접수 3: 장소 등록 4: 장소 미등록
- tret_dttm — DATETIME
- reg_dttm — DATETIME — NOT NULL
- updt_dttm — DATETIME
- reg_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- tret_user_seq — BIGINT — Foreign key → tb_user.seq
- updt_user_seq — BIGINT — Foreign key → tb_user.seq
- reg_store_seq — BIGINT — Foreign key → tb_store.seq
location_keyword
- seq — INT — Primary key — NOT NULL
- keyword — VARCHAR(45)
- keyword_type — INT — 1: 시군구 지역 2: 지하철 3: 거리명
- loc — GEOMETRY
- addr — VARCHAR(255)
- zoom — TINYINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- use_yn — CHAR(1)
- creator_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updater_seq — BIGINT — Foreign key → tb_user.seq
location_keyword_log
- seq — BIGINT — Primary key — NOT NULL
- log_type — INT — 0: 등록 1: 수정 2: 삭제
- contents — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- location_keyword_seq — BIGINT — Foreign key → location_keyword.seq — NOT NULL
- creator_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
push_fail
- seq — BIGINT — Primary key — NOT NULL
- request_type — TINYINT — NOT NULL — 1: 사용자 등록 2: 사용자 삭제 3: 메시지 발송
- http_status — SMALLINT — NOT NULL
- fail_response — VARCHAR(2000)
- exception_class — VARCHAR(300)
- exception_message — VARCHAR(2000)
- create_at — DATETIME — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
push_mngt
- seq — BIGINT — Primary key — NOT NULL
- foodinko_push_yn — CHAR(1) — NOT NULL
- fooditor_push_yn — CHAR(1) — NOT NULL
- reg_dt — DATETIME — NOT NULL
- updt_dt — DATETIME
- reg_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updt_seq — BIGINT — Foreign key → tb_user.seq
store_label
- code_seq — BIGINT — Foreign key → tb_code.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq — NOT NULL
- creator_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- updater_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- use_yn — CHAR(1)
tb_ben_user_id
- seq — INT — Primary key — NOT NULL
- id — VARCHAR(30)
tb_channel
- seq — BIGINT — Primary key — NOT NULL
- channel_name — VARCHAR(100) — NOT NULL
- channel_type — INT — NOT NULL
- master_id — VARCHAR(45)
- user_id — VARCHAR(45)
- create_at — DATETIME — NOT NULL
- update_user_id — VARCHAR(45)
- last_update_at — DATETIME
- use_at — CHAR(1) — NOT NULL
- master_seq — BIGINT — Foreign key → tb_user.seq
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_channel_user
- seq — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(45)
- channel_type — INT — NOT NULL
- channel_user_type — INT — NOT NULL
- use_at — CHAR(1) — NOT NULL
- channel_seq — BIGINT — Foreign key → tb_channel.seq — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_code
- seq — BIGINT — Primary key — NOT NULL
- code — INT — NOT NULL
- value — VARCHAR(255) — NOT NULL
- name_en — VARCHAR(255)
- etc_name_01 — VARCHAR(255)
- etc_name_02 — VARCHAR(255)
- etc_name_03 — VARCHAR(255)
- etc_name_04 — VARCHAR(255)
- etc_name_05 — VARCHAR(255)
- code_order — INT — NOT NULL
- create_user_id — VARCHAR(45)
- create_at — DATETIME — NOT NULL
- update_user_id — VARCHAR(45)
- update_at — DATETIME
- use_yn — CHAR(1) — NOT NULL
- create_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
- type — INT — Foreign key → tb_code_type.seq — NOT NULL
tb_code_type
- seq — BIGINT — Primary key — NOT NULL
- type — INT — NOT NULL
- name_kr — VARCHAR(255) — NOT NULL
- name_eng — VARCHAR(255)
- etc_name_01 — VARCHAR(255)
- etc_name_02 — VARCHAR(255)
- etc_name_03 — VARCHAR(255)
- etc_name_04 — VARCHAR(255)
- etc_name_05 — VARCHAR(255)
- create_user_id — VARCHAR(45)
- create_at — DATETIME — NOT NULL
- update_user_id — VARCHAR(45)
- update_at — DATETIME
- use_at — CHAR(1) — NOT NULL
- create_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_device
- seq — BIGINT — Primary key — NOT NULL
- device_id — VARCHAR(255) — NOT NULL
- device_type — VARCHAR(255)
- notification_token — VARCHAR(255)
- create_at — DATETIME — NOT NULL
- last_update_at — DATETIME
- use_at — CHAR(1) — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq
- create_user_seq — BIGINT — Foreign key → tb_user.seq
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_faq
- seq — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- question — MEDIUMTEXT — NOT NULL
- answer — MEDIUMTEXT
- create_at — DATETIME
- update_at — DATETIME
- user_id — VARCHAR(100) — NOT NULL
- update_user_id — VARCHAR(100)
- use_at — CHAR(1) — NOT NULL
- publish_type — INT — NOT NULL — 1: 공개 9: 대기
- published_at — DATETIME
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_feed
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq — NOT NULL
- feed_subject — VARCHAR(255)
- feed_contents_text — MEDIUMTEXT
- create_at — DATETIME
- last_update_at — DATETIME
- published_at — DATETIME
- user_id — VARCHAR(45)
- Field — BIGINT
- video_file_group — VARCHAR(36)
- update_user_id — VARCHAR(45)
- channel_seq — BIGINT
- channel_name — VARCHAR(100)
- best_at — CHAR(1)
- use_at — CHAR(1) — NOT NULL
- send_at — CHAR(1) — NOT NULL
- push — VARCHAR(255)
- share_cnt — INT — NOT NULL
- send_push_at — DATETIME
tb_feed_comment
- seq — BIGINT — Primary key — NOT NULL
- feed_seq — BIGINT — Foreign key → tb_feed.seq — NOT NULL
- file_seq — BIGINT — Foreign key → comm_file.seq
- file_group — VARCHAR(36)
- comment — VARCHAR(1200)
- upper_seq — BIGINT
- create_at — DATETIME — NOT NULL
- user_id — VARCHAR(45)
- last_update_at — DATETIME
- update_user_id — VARCHAR(45)
- use_at — CHAR(1) — NOT NULL — N: 삭제 Y: 사용 S: 중지
- delete_reason — VARCHAR(400)
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_feed_comment_like
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- user_id — VARCHAR(45)
- feed_comment_seq — BIGINT — Foreign key → tb_feed_comment.seq — NOT NULL
- like_at — TINYINT
- create_at — DATETIME
- last_update_at — DATETIME
tb_feed_comment_violation
- seq — BIGINT — Primary key — NOT NULL
- violation_report_seq — BIGINT — Foreign key → tb_feed_comment_violation_report.seq — NOT NULL
- violation_code — SMALLINT — NOT NULL
- violation_reason — VARCHAR(400) — NOT NULL
- user_id — VARCHAR(45)
- create_at — DATETIME — NOT NULL
- feed_comment_seq — BIGINT — Foreign key → tb_feed_comment.seq
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_feed_comment_violation_report
- seq — BIGINT — Primary key — NOT NULL
- feed_comment_seq — BIGINT — Foreign key → tb_feed_comment.seq — NOT NULL
- create_at — DATETIME — NOT NULL — 최초 신고 시 혹은 기존 신고 처리건 완료 후 생성
- report_state — SMALLINT — NOT NULL
- process_result — VARCHAR(400)
- process_at — DATETIME
- process_user_id — VARCHAR(45)
- process_user_seq — BIGINT — Foreign key → tb_user.seq
tb_feed_log
- seq — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(45)
- log_type — INT — NOT NULL — 0: 저장 1: 수정 2: 삭제
- contents — VARCHAR(255)
- last_update_at — DATETIME
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- feed_seq — BIGINT — Foreign key → tb_feed.seq — NOT NULL
tb_feed_save
- seq — BIGINT — Primary key — NOT NULL
- create_at — DATETIME
- save_at — CHAR(1) — 0: 저장 취소 1: 저장
- last_update_at — DATETIME
- feed_seq — BIGINT — Foreign key → tb_feed.seq
- user_seq — BIGINT — Foreign key → tb_user.seq
tb_file_data
- seq — BIGINT — Primary key — NOT NULL
- save_name — VARCHAR(48) — NOT NULL
- origin_name — VARCHAR(255) — NOT NULL
- path — VARCHAR(128) — NOT NULL
- size — BIGINT — NOT NULL
- ext — VARCHAR(8) — NOT NULL
- mime_type — VARCHAR(255)
- file_order — TINYINT — NOT NULL
- create_at — DATETIME — NOT NULL
- update_at — DATETIME — NOT NULL
- use_at — CHAR(1) — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- feed_seq — BIGINT — Foreign key → tb_feed.seq — NOT NULL
tb_file_profile
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- save_name — VARCHAR(255)
- origin_name — VARCHAR(255)
- path — VARCHAR(255)
- size — BIGINT
- ext — VARCHAR(255)
- mime_type — VARCHAR(255)
- create_at — DATETIME
- update_at — DATETIME
- use_at — CHAR(1) — NOT NULL
- has_webp — TINYINT — NOT NULL
tb_notice
- seq — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- contents_kr — MEDIUMTEXT — NOT NULL
- contents_en — MEDIUMTEXT
- create_at — DATETIME — NOT NULL
- update_at — DATETIME
- user_id — VARCHAR(100)
- update_user_id — VARCHAR(100)
- use_at — CHAR(1) — NOT NULL
- publish_type — INT — NOT NULL — 1: 공개 9: 대기
- published_at — DATETIME — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_notice_system
- seq — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(100) — NOT NULL
- contents_kr — MEDIUMTEXT — NOT NULL
- contents_en — MEDIUMTEXT
- outsid_link — VARCHAR(255)
- create_at — DATETIME — NOT NULL
- update_at — DATETIME
- user_id — VARCHAR(100)
- update_user_id — VARCHAR(100)
- use_at — CHAR(1) — NOT NULL
- publish_type — INT — NOT NULL — 1: 공개 9: 대기
- published_at — DATETIME
- system_status_type — INT — NOT NULL — 0: 작동 1: 중지
- templt_fg — INT — 1: 일반 공지 2: 일반 업데이트
- platform_type — VARCHAR(15)
- os_fg — CHAR(1) — I: IOS A: Android
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_push
- seq — BIGINT — Primary key — NOT NULL
- request_id — VARCHAR(45) — NOT NULL
- message — VARCHAR(1500)
- status_code — VARCHAR(3)
- status_name — VARCHAR(100)
- request_time — DATETIME — NOT NULL
- user_id — VARCHAR(45)
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_refresh_token
- token_id — BIGINT — Primary key — NOT NULL
- expiry_dt — DATETIME
- refresh_count — BIGINT
- token — VARCHAR(255) — NOT NULL
- user_device_seq — BIGINT — Foreign key → tb_user_device.seq — NOT NULL
tb_store
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- name_kr — VARCHAR(200) — NOT NULL
- name_eng — VARCHAR(100)
- addr_kr — VARCHAR(255) — NOT NULL
- addr_eng — VARCHAR(255)
- tel — VARCHAR(40)
- loc — GEOMETRY — NOT NULL
- marker_code — INT — NOT NULL
- marker_code_v3 — INT
- store_type — INT — NOT NULL
- store_menu — VARCHAR(255)
- store_work_time — VARCHAR(255)
- create_at — DATETIME
- published_at — DATETIME
- last_update_at — DATETIME
- status_type — INT — 0: 영업중 1: 폐업 9: 배포 대기 중
- user_id — VARCHAR(45)
- channel_seq — BIGINT
- channel_name — VARCHAR(100)
- update_user_id — VARCHAR(45)
- publish_type — INT — NOT NULL — 0: 미배포 1: 배포
- undistrb_fg — INT — 0: 피드 미완성 1: 매장 폐업 99: 기타
- undistrb_resn — VARCHAR(400) — 미배포 사유가 '기타'인 경우 입력
- nation_type — INT — NOT NULL
- use_at — CHAR(1) — NOT NULL
- map_at — CHAR(1) — NOT NULL
- push_send_yn — CHAR(1)
- alarm_send_yn — CHAR(1)
- first_published_at — DATETIME
tb_store_log
- seq — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(45)
- log_type — INT — NOT NULL
- contents — VARCHAR(225)
- last_update_at — DATETIME
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq — NOT NULL
tb_store_meta
- seq — BIGINT — Primary key — NOT NULL
- meta_type — INT — NOT NULL — 0: 상호 1: 주호 2: 영업 시간 3: 메뉴 4: 전화번호 5: 인스타그램 6: URL 7: 배달 8: 지하철 정보 9: 기타 태그
- meta_value — VARCHAR(400)
- meta_order — INT — NOT NULL
- create_at — DATETIME — NOT NULL
- user_id — VARCHAR(45)
- use_at — CHAR(1)
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq — NOT NULL
tb_store_published_log
- seq — BIGINT — Primary key — NOT NULL
- published_at — DATETIME
- user_id — VARCHAR(45)
- publish_type — BIGINT — NOT NULL — 0: 미배포 1: 배포 8: 미배포 대기 9: 배포 대기
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq
tb_subway
- seq — BIGINT — Primary key — NOT NULL
- name_kr — VARCHAR(80) — NOT NULL
- line — INT
- name_en — VARCHAR(100)
- loc — GEOMETRY — NOT NULL
- create_at — DATETIME — NOT NULL
- user_id — VARCHAR(45)
- last_update_at — DATETIME
- update_user_id — VARCHAR(45)
- use_at — CHAR(1) — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_subway_line
- seq — BIGINT — Primary key — NOT NULL
- name_kr — VARCHAR(30) — NOT NULL
- name_en — VARCHAR(50)
- map_line_name — VARCHAR(10)
- line_order — INT — NOT NULL
- std_date — VARCHAR(8)
- create_at — DATETIME
- user_id — VARCHAR(45) — NOT NULL
- last_update_at — DATETIME
- update_user_id — VARCHAR(45)
- use_at — CHAR(1) — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_subway_loc
- seq — BIGINT — Primary key — NOT NULL
- name_seq — BIGINT — Foreign key → tb_subway_name.seq — NOT NULL
- line_seq — BIGINT — Foreign key → tb_subway_line.seq — NOT NULL
- loc — GEOMETRY — NOT NULL
- create_at — DATETIME
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- user_id — VARCHAR(45)
- last_update_at — DATETIME
- update_user_seq — BIGINT — Foreign key → tb_user.seq
- update_user_id — VARCHAR(45)
- use_at — CHAR(1) — NOT NULL — Y: 사용 중 N: 삭제
tb_subway_name
- seq — BIGINT — Primary key — NOT NULL
- name_kr — VARCHAR(80) — NOT NULL
- name_en — VARCHAR(100)
- map_line_name — VARCHAR(256) — NOT NULL
- name_desc — VARCHAR(256)
- create_at — DATETIME
- user_id — VARCHAR(45) — NOT NULL
- last_update_at — DATETIME
- update_user_id — VARCHAR(45)
- use_at — CHAR(1) — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
tb_system_status
- seq — INT — Primary key — NOT NULL
- system_status_type — INT — NOT NULL — 0: 작동 1: 중지
- user_id — VARCHAR(45)
- create_at — DATETIME — NOT NULL
- os_fg — CHAR(1) — I: IOS A: Android
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_system_version
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- user_id — VARCHAR(45)
- build_version_ios — INT
- build_version_android — INT
- version_major — INT — NOT NULL
- version_minor — INT — NOT NULL
- version_patch — INT — NOT NULL
- version_text — INT — NOT NULL
- version_comment — MEDIUMTEXT — NOT NULL
- create_at — DATETIME — NOT NULL
- update_user_seq — BIGINT — Foreign key → tb_user.seq
- update_user_id — VARCHAR(45)
- update_at — DATETIME
- use_at — CHAR(1) — NOT NULL
- os_fg — CHAR(1) — I: IOS A: Android
tb_tag
- seq — BIGINT — Primary key — NOT NULL
- name — VARCHAR(64) — NOT NULL
tb_tag_store
- seq — BIGINT — Primary key — NOT NULL
- tag_seq — BIGINT — Foreign key → tb_tag.seq — NOT NULL
- store_seq — BIGINT — Foreign key → tb_store.seq — NOT NULL
tb_tag_user
- seq — BIGINT — Primary key — NOT NULL
- tag_seq — BIGINT — Foreign key → tb_tag.seq — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- tag_order — INT — NOT NULL
tb_term
- seq — BIGINT — Primary key — NOT NULL
- subject — VARCHAR(255) — NOT NULL
- contents_kr — MEDIUMTEXT — NOT NULL
- contents_en — MEDIUMTEXT
- create_at — DATETIME — NOT NULL
- update_at — DATETIME
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- user_id — VARCHAR(100)
- update_user_seq — BIGINT — Foreign key → tb_user.seq
- update_user_id — VARCHAR(100)
- use_at — CHAR(1) — NOT NULL
- publish_type — INT — 1: 공개 9: 대기
- published_at — DATETIME
- term_type — INT — 0: 서비스 이용 약관 1: 개인 정보 취급 방법 2: 위치 정보 처리 방침 3: 마케팅 수신 동의
tb_user
- seq — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(45) — NOT NULL
- password — VARCHAR(70) — NOT NULL
- inpn_cd — INT
- phone_num — VARCHAR(20)
- email — VARCHAR(45)
- sign_at — DATETIME — NOT NULL
- nick_name — VARCHAR(64)
- comment — MEDIUMTEXT
- use_at — CHAR(1) — NOT NULL
- insta_id — VARCHAR(50) — 1: 공개 9: 대기
- ini_os_fg — BIGINT
- agre_at — CHAR(1)
- agre_update_at — DATETIME
- gps_at — CHAR(1)
- gps_update_at — DATETIME
- markt_at — CHAR(1)
- markt_update_at — DATETIME
- stplat_at — CHAR(1)
- stplat_update_at — DATETIME
- telno_dupl_yn — CHAR(1)
tb_user_alarm
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- target_user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
- target_seq — BIGINT — NOT NULL
- alarm_message — VARCHAR(300) — NOT NULL
- alarm_type — SMALLINT — NOT NULL
- show_at — SMALLINT — NOT NULL
- create_at — DATETIME — NOT NULL
tb_user_cert_phone
- seq — BIGINT — Primary key — NOT NULL
- user_seq — BIGINT — Foreign key → tb_user.seq
- inpn_cd — INT — NOT NULL
- phone_num — VARCHAR(20) — NOT NULL
- cert_num — CHAR(4) — NOT NULL
- create_at — DATETIME — NOT NULL
- cert_at — DATETIME
- expire_at — DATETIME — NOT NULL
- uuid — VARCHAR(36) — NOT NULL
- using_at — CHAR(1) — NOT NULL
tb_user_device
- seq — BIGINT — Primary key — NOT NULL
- is_refresh_active — BIT(1)
- notification_token — VARCHAR(255)
- device_seq — BIGINT — Foreign key → tb_device.seq — NOT NULL
- device_id — VARCHAR(255) — NOT NULL
- device_type — VARCHAR(255)
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_user_follow_push
- seq — BIGINT — Primary key — NOT NULL
- follow_push_seq — BIGINT
- user_seq — BIGINT — Foreign key → tb_user.seq — NOT NULL
tb_user_follow_push_history
- seq — BIGINT — Primary key — NOT NULL
- message — VARCHAR(1000) — NOT NULL
- request_id — VARCHAR(45)
- status_code — VARCHAR(3)
- status_name — VARCHAR(45)
- request_time — DATETIME
- follow_user_seq — BIGINT — Foreign key → tb_user.seq