dddd
Tables (17)
BATCH_JOB_EXECUTION
- JOB_EXECUTION_ID — BIGINT — NOT NULL
- VERSION — BIGINT
- JOB_INSTANCE_ID — BIGINT — NOT NULL
- CREATE_TIME — DATETIME(6) — NOT NULL
- START_TIME — DATETIME(6)
- END_TIME — DATETIME(6)
- STATUS — VARCHAR(10)
- EXIT_CODE — VARCHAR(2500)
- EXIT_MESSAGE — VARCHAR(2500)
- LAST_UPDATED — DATETIME(6)
BATCH_JOB_EXECUTION_CONTEXT
- JOB_EXECUTION_ID — BIGINT — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
BATCH_JOB_EXECUTION_PARAMS
- JOB_EXECUTION_ID — BIGINT — NOT NULL
- PARAMETER_NAME — VARCHAR(100) — NOT NULL
- PARAMETER_TYPE — VARCHAR(100) — NOT NULL
- PARAMETER_VALUE — VARCHAR(2500)
- IDENTIFYING — CHAR(1) — NOT NULL
BATCH_JOB_EXECUTION_SEQ
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
BATCH_JOB_INSTANCE
- JOB_INSTANCE_ID — BIGINT — NOT NULL
- VERSION — BIGINT
- JOB_NAME — VARCHAR(100) — NOT NULL
- JOB_KEY — VARCHAR(32) — NOT NULL
BATCH_JOB_SEQ
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
BATCH_STEP_EXECUTION
- STEP_EXECUTION_ID — BIGINT — NOT NULL
- VERSION — BIGINT — NOT NULL
- STEP_NAME — VARCHAR(100) — NOT NULL
- JOB_EXECUTION_ID — BIGINT — NOT NULL
- CREATE_TIME — DATETIME(6) — NOT NULL
- START_TIME — DATETIME(6)
- END_TIME — DATETIME(6)
- STATUS — VARCHAR(10)
- COMMIT_COUNT — BIGINT
- READ_COUNT — BIGINT
- FILTER_COUNT — BIGINT
- WRITE_COUNT — BIGINT
- READ_SKIP_COUNT — BIGINT
- WRITE_SKIP_COUNT — BIGINT
- PROCESS_SKIP_COUNT — BIGINT
- ROLLBACK_COUNT — BIGINT
- EXIT_CODE — VARCHAR(2500)
- EXIT_MESSAGE — VARCHAR(2500)
- LAST_UPDATED — DATETIME(6)
BATCH_STEP_EXECUTION_CONTEXT
- STEP_EXECUTION_ID — BIGINT — NOT NULL
- SHORT_CONTEXT — VARCHAR(2500) — NOT NULL
- SERIALIZED_CONTEXT — TEXT
BATCH_STEP_EXECUTION_SEQ
- ID — BIGINT — NOT NULL
- UNIQUE_KEY — CHAR(1) — NOT NULL
comments
- id — bigint(20) — Primary key — NOT NULL — 댓글 ID
- user_id — bigint(20) — Foreign key → users.id — NOT NULL — 유저 ID
- post_id — bigint(20) — Foreign key → posts.id — NOT NULL — 게시글 ID
- content — text — NOT NULL — 댓글 내용
- created_at — timestamp — NOT NULL — 생성 날짜
- updated_at — timestamp — 수정 날짜
follows
- id — bigint(20) — Primary key — NOT NULL
- follower_id — bigint(20) — Foreign key → users.id — NOT NULL — 팔로우 하는 사람
- following_id — bigint(20) — Foreign key → users.id — NOT NULL — 팔로우 당하는 사람
- created_at — timestamp — NOT NULL — 팔로우 날짜
hashtags
- id — bigint(20) — Primary key — NOT NULL — 해시태그 ID
- tag_content — varchar(100) — NOT NULL — 태그 내용
likes
- id — bigint(20) — Primary key — NOT NULL — 좋아요 ID
- user_id — bigint(20) — Foreign key → users.id — NOT NULL — 유저 ID
- post_id — bigint(20) — Foreign key → posts.id — NOT NULL — 게시글 ID
- created_at — timestamp — NOT NULL — 생성 날짜
post_hashtags
- id — bigint(20) — Primary key — NOT NULL
- hashtag_id — bigint(20) — Foreign key → hashtags.id — NOT NULL — 해시태그 ID
- post_id — bigint(20) — Foreign key → posts.id — NOT NULL — 게시글 ID
posts
- id — bigint(20) — Primary key — NOT NULL — 게시글 ID
- user_id — bigint(20) — Foreign key → users.id — 유저 ID
- content — text — 게시글 내용
- media_url — text — NOT NULL — 미디어 URL
- contents_type — enum('IMAGE', 'VIDEO') — NOT NULL — 0: 사진, 1: 영상
- created_at — timestamp — NOT NULL — 생성 날짜
- updated_at — timestamp — 수정 날짜
- deleted — tinyint(1)
- deleted_at — timestamp — 삭제 날짜
soft_delete
- id — bigint(20) — Primary key — NOT NULL
- entity_type — enum('post','user') — NOT NULL
- entity_id — bigint(20) — NOT NULL
- deleted_at — timestamp — NOT NULL
users
- id — bigint(20) — Primary key — NOT NULL — 유저 ID
- username — varchar(50) — NOT NULL — 사용자명
- email — varchar(100) — NOT NULL — 이메일
- password — varchar(255) — NOT NULL — Bcrypt 적용
- profile_img — text — 프로필 이미지 URL
- bio — text — 유저 소개
- created_at — timestamp — NOT NULL — 생성 날짜
- updated_at — timestamp — 수정 날짜
- deleted — tinyint(1)
- deleted_at — timestamp — 삭제 날짜