cocobol

Tables (3)

Likes (Untitled3)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Users.Key — NOT NULL
  • id (Field)
  • user_id (Field2)
  • user (Field3)
  • post (Field4)

Posts (Untitled)

  • Key (key) — NULL 여부 — Primary key — NOT NULL
  • id (auto_increment) — NOT NULL
  • uuid (string) — NOT NULL
  • user_id (Field) — NOT NULL
  • title (Field2) — NOT NULL
  • c_date (Field3) — NOT NULL
  • m_date (Field4) — NULL
  • d_date (Field5) — NULL
  • num (소속 게시판 수) — NOT NULL
  • content (Field6) — NOT NULL
  • click_num (Field7) — NOT NULL
  • like (Field8) — NOT NULL
  • comment_num (Field9) — NOT NULL

Users (Untitled2)

  • Key — Primary key — NOT NULL
  • id (Field)
  • name (Field2)
  • age (Field3)
  • email (Field4)
  • phone (Field5)
  • gender (Field6)
  • c_date (Field7)
  • m_date (Field8)
  • d_date (Field9)
  • user_id (Field10)
  • user_pw (Field11)
  • posts (Field12)
  • likePosts (Field13)