2nd_doori_erd

Tables (17)

block_persons

  • opponent_id — VARCHAR(9) — Primary key — NOT NULL
  • user_id — varchar(9) — NOT NULL — 학번
  • blocked — varchar(1)

chat_members

  • user_id — varchar(9) — NOT NULL — 학번
  • chat_room_id — BIGINT — NOT NULL

chat_messages

  • user_id — varchar(9) — NOT NULL — 학번
  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • message — text
  • created_dt — datetime

chat_rooms

  • chat_room_id — BIGINT — Primary key — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • created_dt — datetime
  • is_finished — tinyint(1)
  • category — varchar(20)
  • notice — varchar(20)

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • user_id — varchar(9) — NOT NULL — 학번
  • Field — varchar(1)
  • comment — varchar(50)
  • created_dt — datetime
  • modified_dt — datetime
  • reply_id — BIGINT — NOT NULL

deliverys

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • location — varchar(20)
  • menu — varchar(50)
  • time — datetime

exercises

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • Field — VARCHAR(255)
  • time — datetime

foods

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • location — varchar(20)
  • menu — varchar(50)
  • time — datetime

foreigners

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • my_countries — varchar(30)
  • your_countries — varchar(30)

hobbies

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • theme — varchar(30)
  • time — datetime

notice

  • notice_id — BIGINT — Primary key — NOT NULL
  • user_id — varchar(9) — NOT NULL — 학번
  • contents — varchar(50)
  • category — varchar(20)
  • created_at — datetime

posts

  • post_id — BIGINT — Primary key — NOT NULL
  • user_id — varchar(9) — NOT NULL — 학번
  • title — varchar(30)
  • content — text
  • writer — varchar(10)
  • creaeted_dt — datetime
  • modified_dt — datetime
  • like — int
  • dislike — int
  • scrap — int

snacks

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • location — varchar(20)
  • menu — varchar(50)
  • time — datetime

study

  • chat_room_id — BIGINT — NOT NULL
  • user_id — varchar(9) — NOT NULL — 학번
  • location — varchar(20)
  • time — datetime
  • type — tinyint(1)
  • subject — varchar(20)

taxi

  • chat_room_id — BIGINT — NOT NULL
  • host_id — varchar(9) — NOT NULL — 학번
  • starting_point — varchar(20)
  • destination — varchar(20)
  • time — datetime

user_post_likes

  • user_id — varchar(9) — NOT NULL — 학번
  • post_id — BIGINT — NOT NULL
  • created_at — datetime

user_scraps

  • user_id — varchar(9) — NOT NULL — 학번
  • post_id — BIGINT — NOT NULL
  • created_at — datetime