homepage

Tables (4)

comment_table (COMMENT_TABLE)

  • IDX (idx) — Primary key — NOT NULL
  • POST_IDX (post_idx) — Foreign key → post_table.IDX — NOT NULL
  • USER_IDX (user_idx) — int — Foreign key → post_table.USER_IDX — NOT NULL
  • CONTENT (content)
  • DEPTH (depth) — int
  • UPLOAD_TIME (upload_time)
  • UPDATE_TIME (update_time)
  • DELETE_TIME (delete_time)

like_table (LIKE_TABLE)

  • IDX (idx) — Primary key — NOT NULL
  • POST_LIKE (post_like)
  • COMMENT_LIKE (comment_like)
  • Field3
  • Field4

post_table (POST_TABLE)

  • IDX (idx) — Primary key — NOT NULL
  • USER_IDX (user_idx) — int — Foreign key → user_table.idx — NOT NULL
  • CONTENT (content)
  • PASSWORD (password)
  • UPLOAD_TIME (upload_time)
  • UPDATE_TIME (update_time)
  • DELETE_TIME (delete_time)

user_table (USER_TABLE)

  • idx — int — Primary key — NOT NULL
  • ID (id) — varchar(20)
  • Password (password) — varchar(255)
  • NAME (name) — varchar(20)
  • EMAIL (email) — varchar(100)
  • PHONE_NUM (phone_num) — varchar(100)
  • Field6 — DATE
  • UPDATE_TIME (update_time) — DATE
  • RESIGN_TIME (resign_time) — DATE
  • SALT (salt) — int