DBsimwa

Tables (3)

Comment (댓글)

  • comment IDX (m_idx) — Primary key — NOT NULL
  • User IDX (u_idx) — BIGINT — Foreign key → User.User IDX — NOT NULL — Auto Increment
  • Date (m_date) — DATETIME — NOT NULL
  • Content (m_content) — VARCHAR(255) — NOT NULL
  • Update_date (m_udate)
  • ContentIDX (c_idx) — BIGINT — Foreign key → Content.ContentIDX — NOT NULL — Auto Increment

Content (게시글)

  • ContentIDX (c_idx) — BIGINT — Primary key — NOT NULL — Auto Increment
  • User IDX (u_idx) — BIGINT — Foreign key → User.User IDX — NOT NULL — Auto Increment
  • Title (c_title) — VARCHAR(255) — NOT NULL
  • Content (c_content) — TEXT — NOT NULL
  • Date (c_date) — DATE — NOT NULL
  • Update_date (c_udate) — DATE

User (유저)

  • User IDX (u_idx) — BIGINT — Primary key — NOT NULL — Auto Increment
  • User Join Day (u_joinday) — DATETIME
  • User Email (u_email) — VARCHAR — NOT NULL — UNIQUE
  • User Nickname (u_nickname) — VARCHAR — NOT NULL — UNIQUE
  • User Password (u_password) — VARCHAR — NOT NULL