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