ADIT

Tables (7)

common_place

  • id — BIGINT
  • place_name — VARCHAR(255) — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • address_name — VARCHAR(255) — NOT NULL
  • road_address_name — VARCHAR(255) — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • sub_category — VARCHAR(20)
  • url — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass

event

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id
  • place_id — BIGINT — Foreign key → common_place.id
  • name — VARCHAR(255) — NOT NULL — 이름
  • category — VARCHAR(20) — NOT NULL — 카테고리
  • start_date — DATE — 시작일
  • end_date — DATE — 종료일
  • memo — TEXT — 메모
  • visited — BOOLEAN — NOT NULL — 벙문 여부
  • visited_at — TIMESTAMP — 방문 일자
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass

image

  • id — BIGINT
  • place_id — BIGINT — Foreign key → user_place.id
  • event_id — BIGINT — Foreign key → event.id
  • url — VARCHAR(255) — NOT NULL — S3 Info
  • file_name — VARCHAR(255) — S3 Info
  • folder_name — VARCHAR(255) — S3 Info
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass

notification

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • event_id — BIGINT — Foreign key → event.id
  • place_id — BIGINT — Foreign key → user_place.id
  • content — TEXT — NOT NULL — 알림 내용
  • is_read — BOOLEAN — NOT NULL — 확인 여부
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass

place_statistics

  • id — BIGINT
  • common_place_id — BIGINT — Foreign key → common_place.id — NOT NULL
  • bookmark_count — INT
  • visit_count — INT
  • last_updated_at — TIMESTAMP

user

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL — 이메일
  • nickname — VARCHAR(50) — NOT NULL — 닉네임
  • social_type — VARCHAR(20) — NOT NULL — 소셜 로그인 타입
  • social_id — VARCHAR(255) — 소셜 아이디
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass
  • token — VARCHAR(255) — NOT NULL

user_place

  • id — BIGINT
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • common_place_id — BIGINT — Foreign key → common_place.id — NOT NULL
  • memo — TEXT
  • visited — BOOLEAN
  • visited_at — TIMESTAMP
  • created_at — TIMESTAMP — @MappedSuperclass
  • modified_at — TIMESTAMP — @MappedSuperclass