diary

Tables (10)

Comment (Untitled9)

  • Comment_id — Primary key — NOT NULL
  • Field
  • Users_id — Foreign key → Users.Users_id — NOT NULL
  • Diary_id — Foreign key → Diary.Diary_id — NOT NULL

Comment Like (Untitled10)

  • Comment_Like_id — Primary key — NOT NULL
  • Field
  • Comment_id — Foreign key → Comment.Comment_id — NOT NULL
  • Users_id — Foreign key → Users.Users_id — NOT NULL

Diary (Untitled2)

  • Diary_id — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

Diary Access (Untitled6)

  • Diary_Acces_id — Primary key — NOT NULL
  • Field
  • Diary_id — Foreign key → Diary.Diary_id — NOT NULL
  • Users_id — BIGINT — Foreign key → Users.Users_id — NOT NULL — 구분자

Diary Image (Untitled5)

  • Diary_Photo_id — Primary key — NOT NULL
  • Field
  • Diary_id — Foreign key → Diary.Diary_id — NOT NULL

Diary Like (Untitled4)

  • DIary_Like_id — Primary key — NOT NULL
  • Field
  • Diary_id — Foreign key → Diary.Diary_id — NOT NULL
  • Users_id — Foreign key → Users.Users_id — NOT NULL

Follow (Untitled3)

  • Follow_id — Primary key — NOT NULL
  • Field
  • Users_id — Foreign key → Users.Users_id — NOT NULL

Region (Untitled7)

  • Region_id — Primary key — NOT NULL
  • Field
  • Rf_id — Foreign key → Region First.Rf_id — NOT NULL

Region First (Untitled8)

  • Rf_id — Primary key — NOT NULL
  • Field

Users

  • Users_id — BIGINT — Primary key — NOT NULL — 구분자
  • email — VARCHAR
  • passowrd (password) — VARCHAR
  • nickname — VARCHAR
  • birthday — DATE
  • inp_day — DATETIME
  • mod_day — DATETIME
  • Region_id — BIGINT — Foreign key → Region.Region_id — NOT NULL — 지역구분자