r
Tables (15)
bid
- bid_id (Key3) — BIGSERIAL — Primary key — NOT NULL
- price — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id (Key2) — BIGSERIAL — Foreign key → user.user_id — NOT NULL
- post_id (Key) — BIGSERIAL — Foreign key → post.post_id — NOT NULL
comment (Untitled4)
- content_id (Key) — Primary key — NOT NULL
- content_id (Key2) — Foreign key → content.content_id — NOT NULL
- user_id (Field2)
- created_at (Field)
- body (Field3)
comment
- comment_id — BIGINT
- content_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- body — TEXT
- created_at — DATETIME
content (Untitled2)
- content_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → member.user_id — NOT NULL
- content_title (Field)
- body (Field8)
- created_at (Field2)
- is_updated (Field3)
- updated_date (Field4)
- view (Field5)
- reaction (Field6)
content
- content_id — BIGINT
- user_id — BIGINT — NOT NULL
- content_title — VARCHAR(200)
- body — TEXT
- created_at — DATETIME
job (Untitled5)
- job_id (Key) — Primary key — NOT NULL
- job_title (Field)
job
- job_id — BIGINT
- job_title — VARCHAR(50) — NOT NULL
member (Untitled3)
- user_id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- gender (Field3)
- login_id (Field4)
- login_password (Field5)
- created_at (Field6)
- job_id (Field7)
member
- user_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- gender — VARCHAR(10)
- login_id — VARCHAR(50)
- login_password — VARCHAR(255)
- created_at — DATETIME
- job_id — BIGINT
member_content_reaction (Untitled6)
- user_id (Field)
- content_id (Field2)
- type (Field3)
member_content_reaction
- user_id — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Primary key — NOT NULL
- type — ENUM('LIKE', 'DISLIKE')
post
- post_id (Key) — BIGSERIAL — Primary key — NOT NULL
- user_id (Key2) — BIGSERIAL — Foreign key → user.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- image_url — VARCHAR(255)
- base_price — BIGINT — NOT NULL
- top_price — BIGINT — NOT NULL
- due_time — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
user
- user_id (Key2) — BIGSERIAL — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- token — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
user_friend (Untitled)
- user_id (Key) — Foreign key → member.user_id — NOT NULL
- friend_id (Field)
- created_at (Field2)
user_friend
- user_id — BIGINT — Primary key — NOT NULL
- friend_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME