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)