kongtoon

Tables (15)

Alarm (알람)

  • id — bigint — Primary key — NOT NULL
  • check (확인 여부) — boolean
  • created_at (생성 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp
  • user_id (사용자 id) — bigint — Foreign key → User.id — NOT NULL
  • comic_id (웹툰 id) — bigint — Foreign key → Comic.id — NOT NULL

Author (작가)

  • id (Key) — bigint — Primary key — NOT NULL
  • author_name (작가명) — varchar(20)
  • introduction (소개) — varchar(500)
  • belong (소속) — varchar(15)
  • created_at (생성일) — Timestamp
  • deleted_at (삭제일) — Timestamp
  • updated_at (수정일) — Timestamp
  • user_id (유저id) — bigint — Foreign key → User.id — NOT NULL

Comic (웹툰)

  • id — bigint — Primary key — NOT NULL
  • name (웹툰 이름) — varchar(30)
  • genre (장르) — varchar(10)
  • summary (줄거리) — varchar(500)
  • publish_day_of_week (연재 요일) — varchar(3)
  • is_complete (완결 여부) — boolean
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp
  • author_id (작가 정보 id) — bigint — Foreign key → Author.id — NOT NULL

Comment (댓글)

  • id — bigint — Primary key — NOT NULL
  • content (댓글 내용) — varchar(500)
  • parent_id (부모 댓글 id) — bigint
  • like_count (좋아요 수) — int
  • visible (표시 여부) — boolean
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp
  • user_id (사용자 id) — bigint — Foreign key → User.id — NOT NULL
  • episode_id (에피소드 id) — bigint — Foreign key → Episode.id — NOT NULL

Comment_Hide (댓글 숨김)

  • idi (id) — bigint — Primary key — NOT NULL
  • created_at (생성 시간) — Timestamp
  • delete_at (삭제 시간) — Timestamp
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • comment_id (댓글 id) — bigint — Foreign key → Comment.id — NOT NULL

Comment_Report (댓글 신고)

  • id — bigint — Primary key — NOT NULL
  • reason (사유) — varchar(50)
  • created_at (생성 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • comment_id (댓글 id) — bigint — Foreign key → Comment.id — NOT NULL

Episode (에피소드)

  • id — bigint — Primary key — NOT NULL
  • title (제목) — varchar
  • episode_number (회차) — int
  • thumbnail_url (썸네일 이미지 url) — varchar(2048)
  • comic_id (웹툰 id) — bigint — Foreign key → Comic.id — NOT NULL
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp

Episode_Image (에피소드 내용 이미지)

  • id — bigint — Primary key — NOT NULL
  • content_image_url (에피소드 이미지 url) — varchar(2048)
  • content_order (이미지 순서) — int
  • episode_id (에피소드id) — bigint — Foreign key → Episode.id — NOT NULL

Follow (팔로우)

  • id — bigint — Primary key — NOT NULL
  • created_at (생성 시간) — Timestamp
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • comic_id (웹툰 id) — bigint — Foreign key → Comic.id — NOT NULL

Likes (좋아요)

  • id — bigint — Primary key — NOT NULL
  • like_type (좋아요 타입) — varchar(15)
  • reference_id (참조 id) — bigint
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • created_at (생성 시간) — Timestamp

Star (별점)

  • id — bigint — Primary key — NOT NULL
  • score (점수) — int
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • episode_id (에피소드 id) — bigint — Foreign key → Episode.id — NOT NULL

Thumbnail (웹툰 썸네일)

  • id — bigint — Primary key — NOT NULL
  • thumbnail_type (썸네일 종류) — varchar(10)
  • image_url (썸네일 이미지 url) — varchar(2048)
  • comic_id (웹툰 id) — bigint — Foreign key → Comic.id — NOT NULL
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp

User (유저)

  • id — bigint — Primary key — NOT NULL
  • login_id (로그인 id) — varchar(15)
  • name (사용자 이름) — varchar(20)
  • email (이메일) — varchar(320)
  • nickname (닉네임) — varchar(15)
  • password (비밀번호) — varchar
  • authority (권한) — varchar(20)
  • set_alarm (알람 설정 여부) — boolean
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • deleted_at (삭제 시간) — Timestamp

View (조회수 로그)

  • id — bigint — Primary key — NOT NULL
  • user_id (유저 id) — bigint — Foreign key → User.id — NOT NULL
  • episode_id (에피소드 id) — bigint — Foreign key → Episode.id — NOT NULL
  • first_access_time (처음 조회 시간) — Timestamp
  • last_access_time (마지막 조회 시간) — Timestamp

realtime_comic_ranking (Untitled)

  • id — bigint — Primary key — NOT NULL
  • record_time (기록 시간) — varchar(10)
  • record_date (기록 날짜) — date
  • ranks (랭킹) — int
  • views (조회수) — bigint
  • created_at (생성 시간) — Timestamp
  • updated_at (수정 시간) — Timestamp
  • comic_id (웹툰 id) — bigint — Foreign key → Comic.id — NOT NULL