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