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