OpusDB
Tables (6)
comment_likes
- member_id — INT — Primary key — NOT NULL
- comment_id — INT — Primary key — NOT NULL
- status — VARCHAR(10)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
comments
- comment_id — INT
- post_id — INT — NOT NULL
- user_id — INT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
member
- member_id — INT
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
pin_likes
- member_id — INT — Primary key — NOT NULL
- pin_id — INT — Primary key — NOT NULL
- status — VARCHAR(10)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
pins
- pin_id — INT
- member_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
tokens
- r_key — INT — Primary key — NOT NULL
- r_value — VARCHAR(255)