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 — 삭제 날짜