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