사물함

테이블 (8)

Allocate

  • id — BIGINT — 기본 키 — NOT NULL
  • apply_id — BIGINT
  • locker_id — VARCHAR(10)
  • student_id — BIGINT
  • apply_form_id — BIGINT
  • apply_id (apply_id2) — BIGINT — 외래 키 → Apply.apply_id — NOT NULL
  • name — VARCHAR(10) — 외래 키 → Locker.name — NOT NULL
  • student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL
  • apply_form_id (apply_form_id2) — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL

Apply

  • apply_id — BIGINT — 기본 키 — NOT NULL
  • student_id — BIGINT
  • apply_form_id — BIGINT
  • first_floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1')
  • first_height — ENUM('TOP','MIDDLE','BOTTOM')
  • second_floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1')
  • second_height — ENUM('TOP','MIDDLE','BOTTOM')
  • period — ENUM('PRIMARY','ADDITIONAL','REPLACEMENT')
  • status — ENUM('APPLY','APPROVE','REJECT','BROKEN_APPLY')
  • createdAt — TIMESTAMP
  • updateAt — TIMESTAMP
  • apply_form_id (apply_form_id2) — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL
  • student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL

ApplyForm

  • apply_form_id — BIGINT — 기본 키 — NOT NULL
  • year — INT
  • semester — INT
  • first_apply_start_date — TIMESTAMP
  • first_apply_end_date — TIMESTAMP
  • semester_end_date — TIMESTAMP
  • status — ENUM('ACTIVE', 'INACTIVE')

Dues

  • id — BIGINT — 기본 키 — NOT NULL
  • dues — BOOLEAN — NOT NULL
  • student_id — BIGINT — 외래 키 → Student.student_id — NOT NULL

Locker

  • name — VARCHAR(10) — 기본 키 — NOT NULL
  • floor — ENUM('FLOOR_L', 'FLOOR_3F', 'FLOOR_B1') — NOT NULL
  • height — INT — NOT NULL
  • pw — VARCHAR(4) — NOT NULL
  • broken — BOOLEAN — NOT NULL
  • apply_form_id — BIGINT — 외래 키 → ApplyForm.apply_form_id — NOT NULL

OAuth2UserInfo

  • oauth2_user_info_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255)
  • provider — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • student_id — BIGINT
  • student_id (student_id2) — BIGINT — 외래 키 → Student.student_id — NOT NULL

Report

  • apply_id — BIGINT — 외래 키 → Apply.apply_id — NOT NULL
  • content — VARCHAR(1000)

Student

  • student_id — BIGINT — 기본 키 — NOT NULL
  • student_number — VARCHAR(15) — NOT NULL
  • name — VARCHAR(50)
  • role — ENUM('ROLE_STUDENT', 'ROLE_EXECUTIVE', 'ROLE_FINANCE')