ㅁㄴㅇㄹㄴㅁㅇㄹ

Tables (8)

Follower

  • follower_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • follower_member — BIGINT

board_like

  • feed_like_id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
  • user_id — BIGINT — Foreign key → feed.user_id — NOT NULL — ID
  • company_id — BIGINT — Foreign key → feed.company_id — NOT NULL

comment

  • comment_id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
  • feed_user_id — BIGINT — Foreign key → feed.user_id — NOT NULL — ID
  • company_id — BIGINT — Foreign key → feed.company_id — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
  • group — INT
  • depth — INT
  • parent — INT
  • content — VARCHAR(50)
  • created_datetime — DATETIME

comment_like

  • comment_like_id — BIGINT — Primary key — NOT NULL
  • comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
  • user_id — BIGINT — Foreign key → comment.user_id — NOT NULL — ID
  • company_id — BIGINT — Foreign key → comment.company_id — NOT NULL

company

  • company_id — BIGINT — Primary key — NOT NULL
  • company_email — VARCHAR(45)
  • company_password — VARCHAR(45)
  • company_name — VARCHAR(45)
  • company_nickname — VARCHAR(45)
  • company_tel — VARCHAR(20)
  • company_address — VARCHAR(200)
  • created_datetime — DATETIME
  • modified_datetime — DATETIME
  • approval — BOOLEAN

feed

  • feed_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
  • company_id — BIGINT — Foreign key → company.company_id — NOT NULL
  • content — VARCHAR(1000)
  • sunin — BOOLEAN
  • created_datetime — DATETIME
  • modified_datetime — DATETIME

hashtag

  • hashtag_id — BIGINT — Primary key — NOT NULL
  • feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
  • company_id — BIGINT — Foreign key → feed.company_id — NOT NULL
  • hashtag — VARCHAR(45)

user

  • user_id — BIGINT — Primary key — NOT NULL — ID
  • user_email — VARCHAR(45)
  • user_password — VARCHAR(45)
  • user_name — VARCHAR(45)
  • user_nickname — VARCHAR(45)
  • user_tel — VARCHAR(20)
  • user_address — VARCHAR(200)
  • created_datetime — DATETIME
  • modified_datetime — DATETIME