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