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 — 지역구분자