konkuk_campustown
Tables (19)
alimtalk_outbox
- id — BIGINT — Primary key — NOT NULL
- template_code — VARCHAR(255) — NOT NULL
- to_phone — VARCHAR(255) — NOT NULL
- message_id — VARCHAR(255) — SENS 응답 messageId
- content — LONGTEXT — NOT NULL
- buttons_json — LONGTEXT — NOT NULL
- status — VARCHAR(255) — NOT NULL — PENDING / SENT / FAILED
- last_error — LONGTEXT
- sent_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
application_document
- id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → program_application.id — NOT NULL
- slot_id — BIGINT — Foreign key → program_document_slot.id — NOT NULL
- file_url — VARCHAR(2000) — NOT NULL
- original_file_name — VARCHAR(255)
authority
- id — BIGINT — Primary key — NOT NULL
- role_name — VARCHAR(255) — ROLE_USER / ROLE_ADMIN
- member_id — BIGINT — Foreign key → member.id
companies
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(8) — NOT NULL — 기업 코드(8자리, 0-9A-Z)
- enabled — TINYINT(1) — NOT NULL — 입주 여부(true=입주중)
- name — VARCHAR(255) — 기업명
- description — VARCHAR(255) — 기업 한줄 소개
- website_url — VARCHAR(255)
- contact_number — VARCHAR(255)
- contact_email — VARCHAR(255)
- logo — VARCHAR(1000)
- company_type — VARCHAR(255) — 분야
- office_location_id — BIGINT — Foreign key → office_location.id
- office_unit_id — BIGINT — Foreign key → office_unit.id
- move_in_date — DATE — 입주일
- expected_move_out_date — DATE — 퇴거 예정일
- created_at — DATETIME(6) — NOT NULL
company_member
- id — BIGINT — Primary key — NOT NULL
- kt_user_id — VARCHAR(16) — KT 출입 게이트 사용자 ID(16자리 0패딩)
- email — VARCHAR(255)
- name — VARCHAR(255)
- phone_number — VARCHAR(255)
- position — VARCHAR(255) — 직책
- member_role — VARCHAR(20) — NOT NULL — REPRESENTATIVE / MEMBER
- status — VARCHAR(255) — PENDING / APPROVED / DEACTIVATED
- member_id — BIGINT — Foreign key → member.id
- company_id — BIGINT — Foreign key → companies.id
- created_at — DATE
management_cards
- id — BIGINT — Primary key — NOT NULL
- company_id — BIGINT — Foreign key → companies.id — NOT NULL
- target_month — VARCHAR(7) — NOT NULL — YYYY-MM
- status — VARCHAR(20) — NOT NULL — DRAFT / SUBMITTED
- current_step — INT — 1~5
- submitted_at — DATETIME(6)
- company_info — JSON — 1단계: 기업현황
- team_members — JSON — 2단계: 입주팀 현황
- annual_financials — JSON — 3단계: 연도별 성과
- cagr_last_2_years — VARCHAR(255) — 최근 2년 성장률
- investments — JSON — 4-1: 투자실적
- support_programs — JSON — 4-2: 지원사업
- competition_awards — JSON — 4-3: 공모전/경진대회
- intellectual_properties — JSON — 4-4: 지적재산권
- item_info — JSON — 5단계: 아이템 설명
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
member
- id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(255) — NOT NULL — 로그인 아이디
- password — VARCHAR(255)
- enabled — TINYINT(1) — NOT NULL — 계정 활성화 여부
office_image
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- image_url — VARCHAR(255)
- map_id — BIGINT — Foreign key → office_location.id — office_location.id
office_location
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- summary — VARCHAR(255)
- building_name — VARCHAR(255) — 실제 건물 위치
- location — VARCHAR(255) — 위치 이미지 URL
- latitude — DOUBLE — NOT NULL — 위도
- longitude — DOUBLE — NOT NULL — 경도
- address — VARCHAR(255)
- thumbnail — VARCHAR(255) — 공간소개 썸네일
- icon — VARCHAR(255) — 지도 위 아이콘
- location_url — VARCHAR(255) — 네이버지도 URL
office_unit
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- map_id — BIGINT — Foreign key → office_location.id — office_location.id
place_notice
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- is_pinned — TINYINT(1) — NOT NULL — 상단 고정 여부
- pinned_order — INT — 고정 순서
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
program_application
- id — BIGINT — Primary key — NOT NULL
- program_id — BIGINT — Foreign key → support_program.id — NOT NULL
- company_member_id — BIGINT — Foreign key → company_member.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- submitted_at — DATETIME(6)
- company_name — VARCHAR(255) — NOT NULL
- applicant_name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- phone_number — VARCHAR(255)
- pledge_agreed_at — DATETIME(6)
- pledge_content_snapshot — LONGTEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
program_application_decision_log
- id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → program_application.id — NOT NULL
- action — VARCHAR(20) — NOT NULL
- reason — VARCHAR(1000)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
program_application_supplement
- id — BIGINT — Primary key — NOT NULL
- application_id — BIGINT — Foreign key → program_application.id — NOT NULL
- slot_id — BIGINT — Foreign key → program_document_slot.id — NOT NULL
- reason — VARCHAR(1000) — NOT NULL
- resolved — BIT(1) — NOT NULL
- resolved_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
program_document_slot
- id — BIGINT — Primary key — NOT NULL
- program_id — BIGINT — Foreign key → support_program.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- template_file_url — VARCHAR(2000)
- guide_text — VARCHAR(255)
program_guide_notice
- id — BIGINT — Primary key — NOT NULL
- program_id — BIGINT — Foreign key → support_program.id — NOT NULL
- content — LONGTEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
reservation
- id — BIGINT — Primary key — NOT NULL
- reservation_date — DATE — NOT NULL
- start_at — TIME — NOT NULL
- end_at — TIME — NOT NULL
- purpose — VARCHAR(255) — NOT NULL — 예약 목적
- status — VARCHAR(255) — NOT NULL — PENDING / APPROVED / CANCELLED
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- space_id — BIGINT — Foreign key → space.id
- company_member_id — BIGINT — Foreign key → company_member.id
space
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255)
- capacity — INT — 수용 인원
- image_url — VARCHAR(255)
- space_number — VARCHAR(255)
- space_type — VARCHAR(255) — NOT NULL — OFFICE / DESK / KITCHEN / STUDIO
- map_id — BIGINT — Foreign key → office_location.id — office_location.id
support_program
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- introduction — LONGTEXT — NOT NULL
- category — VARCHAR(255) — NOT NULL
- business_year — INT — NOT NULL
- apply_start_at — DATETIME(6) — NOT NULL
- apply_end_at — DATETIME(6) — NOT NULL
- eligibility — VARCHAR(30) — NOT NULL
- pledge_content — LONGTEXT
- published_at — DATETIME(6)
- result_notified_at — DATETIME(6)
- ended_at — DATETIME(6)
- suspended — BIT(1) — NOT NULL
- suspension_reason — VARCHAR(255)
- deleted — BIT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)