IDE

Tables (10)

code

  • code_id (Key) — BIGINT — Primary key — NOT NULL
  • html_code_url — VARCHAR(255)
  • css_code_url — VARCHAR(255)
  • js_code_url — VARCHAR(255)

conversation

  • conversation_id (Key2) — BIGINT — Primary key — NOT NULL
  • member_id (Key) — BIGINT — Foreign key → member.member_id — NOT NULL

image

  • image_id (Key) — BIGINT — Primary key — NOT NULL
  • reply_img_id (Key2) — BIGINT — Foreign key → reply_image.reply_img_id — NOT NULL
  • file_path — VARCHAR(255)
  • message_id — BIGINT

member

  • member_id (Key) — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(50)
  • password — VARCHAR(255)

message

  • message_id (Key) — BIGINT — Primary key — NOT NULL
  • conversation_id (Key2) — BIGINT — Foreign key → conversation.conversation_id — NOT NULL
  • content — TEXT
  • sender (time) — VARCHAR(255)
  • timestamp — BIGINT

post

  • post_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT

post_image

  • post_img_id (Key) — BIGINT — Primary key — NOT NULL
  • post_id (Key2) — BIGINT — Foreign key → post.post_id — NOT NULL

reply

  • reply_id (Key) — BIGINT — Primary key — NOT NULL
  • code_id (Key2) — BIGINT — Foreign key → code.code_id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → post.post_id — NOT NULL
  • member_id (Key22) — BIGINT — Foreign key → post.member_id — NOT NULL

reply_image

  • reply_img_id (Key2) — BIGINT — Primary key — NOT NULL
  • reply_id (Key) — BIGINT — Foreign key → reply.reply_id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → reply.post_id — NOT NULL
  • member_id (Key22) — BIGINT — Foreign key → reply.member_id — NOT NULL

save_code

  • save_code_id (Key) — BIGINT — Primary key — NOT NULL
  • member_id (Key2) — BIGINT — Foreign key → member.member_id — NOT NULL
  • code_id (Key3) — BIGINT — Foreign key → code.code_id — NOT NULL