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