inha_next_campus_db

Tables (10)

category

  • category_id (Key) — bigint — Primary key — NOT NULL
  • category_name (Field) — varchar(50) — NOT NULL

comment

  • comment_id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
  • member_id (Key3) — bigint — Foreign key → member.member_id — NOT NULL — comment writer
  • content (Field) — text
  • created_at (Field2) — DATETIME — NOT NULL
  • updated_at (Field3) — DATETIME — NOT NULL

fcm_token

  • fcm_token_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Field) — BIGINT — NOT NULL
  • fcm_token — VARCHAR(255) — NOT NULL
  • updated_at — TIMESTAMP
  • member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL

location

  • location_id (Key) — bigint — Primary key — NOT NULL
  • location_name (Field) — varchar(100) — NOT NULL

member

  • member_id (Key) — bigint — Primary key — NOT NULL
  • student_id (Field2) — bigint — NOT NULL
  • password (Field4) — varchar(255) — NOT NULL
  • name (Field6) — varchar(100) — NOT NULL
  • email (Field) — varchar(255) — NOT NULL
  • department (Field5) — varchar(100) — NOT NULL
  • role (Field3) — ENUM('USER', 'ADMIN') — NOT NULL
  • refresh_token (Field7) — varchar(255)
  • refresh_expiry (Field8) — DATETIME

notification

  • notification_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL — receiver
  • title (Field3) — varchar(255) — NOT NULL — 알림 제목
  • message (Field) — text — NOT NULL — 알림 내용
  • link (Field5) — varchar(255)
  • is_read (Field4) — boolean — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL

post

  • post_id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL — writer
  • location_id (Key3) — bigint — Foreign key → location.location_id — 발견 위치
  • location_detail (Field11) — varchar(255) — 발견 위치의 세부정보
  • title (Field) — varchar(255) — NOT NULL
  • content (Field2) — text
  • stored_location (Field7) — varchar(255) — 보관 위치
  • status (Field5) — ENUM('UNCOMPLETED', 'COMPLETED', 'POLICE') — NOT NULL
  • post_type (Field6) — ENUM('LOST', 'FIND', 'NOTICE')
  • is_personal (Field10) — boolean — NOT NULL
  • student_id (Field8) — varchar(10)
  • created_at (Field3) — DATETIME — NOT NULL
  • updated_at (Field4) — DATETIME — NOT NULL

post_category (item)

  • post_category_id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
  • category_id (Key3) — bigint — Foreign key → category.category_id — NOT NULL

post_image

  • post_image_id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
  • original_file_name (Field2) — varchar(255)
  • stored_file_name (Field3) — varchar(255)
  • createdAt (Field4) — DATETIME — NOT NULL
  • updatedAt (Field5) — DATETIME — NOT NULL

receiver

  • receiver_id (Key) — bigint — Primary key — NOT NULL
  • post_id (Key2) — bigint — Foreign key → post.post_id — NOT NULL
  • name (Field) — varchar(100) — NOT NULL
  • email (Field2) — varchar(255) — NOT NULL
  • phone_number (Field4) — varchar(30) — NOT NULL
  • student_id (Field3) — varchar(10)
  • created_at (Field5) — DATETIME — NOT NULL
  • updated_at (Field6) — DATETIME — NOT NULL