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