innovationcamp_hw4
Tables (7)
content_like
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → contents.id — NOT NULL
- id (Key22) — Long — Foreign key → contents.id — NOT NULL
contents
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → user.id — NOT NULL
- title (Field1) — String
- name (Field2) — String
- contents (Field3) — String
- content_like_count (Field4) — Long
- reply_like_count (Field5) — Long
- re_reply_like_count (Field6) — Long
- created_at (Field7) — String
- modified_at (Field8) — String
re_reply
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → reply.id — NOT NULL
- id (Key22) — Long — Foreign key → reply.id — NOT NULL
- id (Key222) — Long — Foreign key → reply.id — NOT NULL
- username (Field1) — String
- re_reply (Field2) — String
- re_reply_like_count (Field3) — Long
- created_at (Field4) — String
- modified_at (Field5) — String
re_reply_like
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → re_reply.id — NOT NULL
- id (Key22) — Long — Foreign key → re_reply.id — NOT NULL
- id (Key222) — Long — Foreign key → re_reply.id — NOT NULL
- id (Key2222) — Long — Foreign key → re_reply.id — NOT NULL
reply
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → contents.id — NOT NULL
- id (Key22) — Long — Foreign key → contents.id — NOT NULL
- username (Field1) — String
- reply (Field2) — String
- count_re_reply (Field3) — String
- re_reply_like_count (Field4) — Long
- created_at (Field5) — String
- modified_at (Field6) — String
reply_like
- id (Key) — Long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → reply.id — NOT NULL
- id (Key22) — Long — Foreign key → reply.id — NOT NULL
- id (Key222) — Long — Foreign key → reply.id — NOT NULL
user
- id (Key) — Long — Primary key — NOT NULL
- uername (Field1) — String
- password (Field2) — String
- created_at (Field3) — String
- modified_at (Field4) — String