ddaom

Tables (5)

content (Untitled4)

  • content_id (소설내용 식별자) — varchar — Primary key — NOT NULL
  • content (소설내용) — longtext
  • step (단계) — enum
  • novel_id (소설 식별자) — varchar — Foreign key → novel.novel_id — NOT NULL
  • writer_id (유저 식별자) — varchar — Foreign key → user.user_id — NOT NULL

keyword (Untitled3)

  • keyword_id (키워드 식별자) — varchar — Primary key — NOT NULL
  • content (키워드 내용) — varchar
  • thumbnail (이미지) — varchar

novel (Untitled)

  • novel_id (소설 식별자) — bigint — Primary key — NOT NULL
  • genre (장르) — varchar
  • keyword (주제어) — varchar
  • title (제목) — varchar
  • status (상태) — varchar
  • user_id (유저 식별자) — bigint — Foreign key → user.user_id — NOT NULL
  • description (소개) — varchar
  • intro (서론) — varchar
  • main (본론) — varchar
  • conclusion (결론) — varchar
  • thumbnail_id (이미지 식별자) — varchar — Foreign key → thumbnail.thumbnail_id — NOT NULL

thumbnail (Untitled6)

  • thumbnail_id (이미지 식별자) — varchar — Primary key — NOT NULL
  • url (이미지 주소) — varchar

user

  • user_id (유저 식별자) — bigint — Primary key — NOT NULL
  • nickName (닉네임) — varchar
  • gender (성별) — varchar
  • age (나이) — bigint
  • thumbnail (썸네일) — varchar
  • Field