eodigatji
Tables (5)
comment (댓글)
- id (Key) — BIGINT — Primary key — NOT NULL — 댓글 ID
- user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL — 댓글 작성자
- post_id (Key3) — BIGINT — Foreign key → post.id — NOT NULL — 게시글 ID
- content (Field) — TEXT — NOT NULL — 댓글 내용
- created_at (Field2) — TIMESTAMP — NOT NULL — 생성일
location (보관장소)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(100) — NOT NULL — 건물 이름
- detail (Field2) — VARCHAR(255) — NOT NULL — 장소 상세 위치
- number (Field3) — VARCHAR(20) — NOT NULL — 문의 전화번호
- created_at (Field4) — TIMESTAMP — NOT NULL
notification (알림)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key3) — BIGINT — Foreign key → user.id — NOT NULL
- is_read (Field) — BOOLEAN — NOT NULL — 알림 여부
- created_at (Field2) — TIMESTAMP — NOT NULL — 생성일
post (게시글)
- id (Key) — BIGINT — Primary key — NOT NULL — 게시글 ID
- location_id (Key3) — BIGINT — Foreign key → location.id — NOT NULL — 보관 장소 ID
- user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL — 작성자 ID
- title (Field) — VARCHAR(100) — NOT NULL — 제목
- description (Field2) — TEXT — NOT NULL — 게시글 설명
- type (Field5) — VARCHAR(20) — NOT NULL — LOST,FOUND
- category (Field6) — VARCHAR(20) — NOT NULL — ELECTRONICS, WALLET, FASHION, BOOK, ETC
- created_at (Field3) — TIMESTAMP — NOT NULL — 생성일
- updated_at (Field4) — TIMESTAMP — 수정일
user (사용자)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- student_number (Field2) — VARCHAR(20) — NOT NULL
- nickname (Field4) — VARCHAR(30) — NOT NULL
- temperature (Field3) — INT — NOT NULL
- created_at (Field5) — TIMESTAMP — NOT NULL