SSAFYGATE

Tables (6)

articles (공지)

  • id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • pro_id (FK) — NOT NULL — Foreign key → pros.id — NOT NULL
  • title (제목) — NOT NULL
  • content (내용) — NOT NULL
  • created_at (생성시간) — NOT NULL, current_timestamp
  • updated_at (수정시간) — NOT NULL, current_timestamp on update current_timestamp

pro_surveys (설문형식)

  • id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • text (설문내용) — NOT NULL
  • checked (수정여부) — DEFALUT 0
  • created_at (생성시간) — NOT NULL, current_timestamp
  • updated_at (수정시간) — NOT NULL, current_timestamp on update current_timestamp

pros (계정(프로님들))

  • id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • region_id (FK) — NOT NULL — Foreign key → regions.id — NOT NULL
  • name (이름) — NOT NULL
  • userid (아이디) — NOT NULL
  • password (비밀번호) — NOT NULL

regions (지역)

  • id (PK) — NOT NULL, AUTO INCREMENT — Primary key — NOT NULL
  • name (지역이름) — NOT NULL

students (학생)

  • id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • region_id (FK) — NOT NULL — Foreign key → regions.id — NOT NULL
  • name (이름) — NOT NULL
  • class (반) — NOT NULL
  • profile_img (사진) — NULL

surveys (설문)

  • id (PK) — NOT NULL, AUTO_INCREMENT — Primary key — NOT NULL
  • student_id (FK) — NOT NULL — Foreign key → students.id — NOT NULL
  • body_temperature (체온) — DEFALUT 0
  • danger (위험지역 방문여부) — DEFAULT 0
  • body_check (몸상태) — DEFAULT 0
  • created_at (생성시간) — NOT NULL, current_timestamp
  • updated_at (수정시간) — NOT NULL, current_timestamp on update current_timestamp