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