통합 디비

테이블 (20)

allocate

  • id — BIGINT — 기본 키 — NOT NULL
  • apply_id — BIGINT
  • locker_id — VARCHAR(10)
  • student_id — BIGINT
  • apply_form_id — BIGINT

apply

  • apply_id — BIGINT — 기본 키 — NOT NULL
  • created_at — timestamp
  • update_at — timestamp
  • student_id — BIGINT
  • first_floor — SMALLINT
  • first_height — SMALLINT
  • second_floor — SMALLINT
  • second_height — SMALLINT
  • period — VARCHAR
  • status — VARCHAR(255)
  • apply_form_id — BIGINT — 외래 키 → apply_form.apply_form_id — NOT NULL

apply_form

  • apply_form_id — BIGINT — 기본 키 — NOT NULL
  • year — INT
  • semester — INT
  • first_apply_start_date — datetime
  • first_apply_end_date — datetime
  • semester_end_date — datetime
  • status — SMALLINT

auth_client_domains

  • domain_id — BIGINT — 기본 키 — NOT NULL
  • domain — VARCHAR(255)
  • client_id — BIGINT — 외래 키 → auth_clients.client_id — NOT NULL

auth_clients

  • client_id — BIGINT — 기본 키 — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • client_name — VARCHAR(100) — NOT NULL
  • client_description — VARCHAR(500)
  • jwt_secret — VARCHAR(500) — NOT NULL
  • status — VARCHAR(255) — NOT NULL

authorization_codes

  • code — VARCHAR(36) — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • redirect_uri — VARCHAR(500) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used — BIT(1) — NOT NULL
  • created_at — TIMESTAMP
  • client_id — BIGINT — 외래 키 → auth_clients.client_id — NOT NULL

deprecated_social_accounts (social_accounts)

  • social_id — BIGINT — 기본 키 — NOT NULL
  • email
  • provider_type — VARCHAR(50) — NOT NULL — google, kakao, github 등
  • provider_key — VARCHAR(255) — NOT NULL — 제공자 측 식별자
  • created_at — TIMESTAMP
  • student_id

dues

  • dues_id — BIGINT — 기본 키 — NOT NULL
  • student_id — BIGINT — 외래 키 → student.student_id — NOT NULL — 납부 학생
  • depositor_name — VARCHAR(50) — NOT NULL — 입금자명
  • amount — INT — NOT NULL — 납부 금액
  • remaining_semesters — INT — NOT NULL — 잔여 학기
  • submitted_at — DATETIME — NOT NULL — 납부일
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

locker

  • name — VARCHAR(10) — 기본 키 — NOT NULL
  • floor — VARCHAR(255) — NOT NULL
  • height — INT — NOT NULL
  • pw — VARCHAR(4) — NOT NULL
  • broken — BIT(1) — NOT NULL
  • allocate_id — BIGINT — 외래 키 → allocate.id — NOT NULL

locker_allocate

  • allocate_id — BIGINT — 기본 키 — NOT NULL
  • apply_id — BIGINT — 외래 키 → locker_apply.apply_id
  • form_id — BIGINT — 외래 키 → locker_apply_form.form_id
  • locker_name — VARCHAR(10)
  • student_id — BIGINT — 외래 키 → student.student_id — 배정받은 학생

locker_apply

  • apply_id — BIGINT — 기본 키 — NOT NULL
  • form_id — BIGINT — 외래 키 → locker_apply_form.form_id
  • student_id — BIGINT — 외래 키 → student.student_id — 신청자
  • first_floor — SMALLINT
  • first_height — SMALLINT
  • second_floor — SMALLINT
  • second_height — SMALLINT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

locker_apply_form

  • form_id — BIGINT — 기본 키 — NOT NULL
  • year — INT — NOT NULL
  • semester — INT — NOT NULL
  • first_apply_start_date — DATETIME
  • first_apply_end_date — DATETIME
  • semester_end_date — DATETIME
  • status — SMALLINT

locker_report

  • report_id — BIGINT — 기본 키 — NOT NULL
  • apply_id — BIGINT — 외래 키 → locker_apply.apply_id — NOT NULL
  • content — VARCHAR(255)

oauth_user_info

  • oauth_user_info_id — BIGINT — 기본 키 — NOT NULL
  • student_id — BIGINT — 기본 키
  • email — VARCHAR(255)
  • provider — VARCHAR(255)
  • provider_id — VARCHAR(255)

official_post (CopyOftech_events)

  • event_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • deleted — BIT(1)

provider

  • provider_id — bigint — 기본 키 — NOT NULL
  • email — varchar(255) — NOT NULL
  • provider_name — varchar(255) — NOT NULL
  • provider_key — varchar(255) — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • student_id — BIGINT — 외래 키 → student.student_id — NOT NULL — 통합 식별자

qr_auth_log

  • log_id — BIGINT — 기본 키 — NOT NULL
  • student_number — VARCHAR(20) — NOT NULL — 로그 당시 학번
  • student_name — VARCHAR(50) — NOT NULL
  • scan_date — DATE — NOT NULL
  • scanned_by — VARCHAR(255) — NOT NULL — 스캔한 관리자
  • dues_paid — BIT(1) — NOT NULL
  • created_at — TIMESTAMP

report

  • apply_id — BIGINT — 기본 키 — NOT NULL
  • content — VARCHAR(255)
  • apply_id (apply_id2) — BIGINT — 외래 키 → apply.apply_id — NOT NULL

student

  • student_id — BIGINT — 기본 키 — NOT NULL — 통합 식별자
  • student_number — VARCHAR(20) — NOT NULL — 학번 (비즈니스 키)
  • name — VARCHAR(50) — NOT NULL — 이름
  • email — VARCHAR(255) — NOT NULL — 이메일 (연락처)
  • major — VARCHAR(100) — 학과
  • role — VARCHAR(20) — 권한(ROLE_STUDENT, ROLE_ADMIN)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

tech_events

  • event_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • start_date — DATETIME
  • end_date — DATETIME
  • deleted — BIT(1)