test
Tables (6)
block_friends
- block_friendscol — INT — Primary key — NOT NULL
- user — VARCHAR(32) — Foreign key → users.id
- friend — VARCHAR(32)
- INDEX — `fk_users_block_friends`
chatting_rooms
- room_num — BIGINT — Primary key — NOT NULL
- user — VARCHAR(32)
- user2 — VARCHAR(32)
friends
- friendscol — INT — Primary key — NOT NULL
- user — VARCHAR(64) — Foreign key → users.id
- friend — VARCHAR(64)
- status — VARCHAR(16)
- INDEX — `fk_users_friends`
hobbies
- hobbiescol — INT — Primary key — NOT NULL
- user — VARCHAR(64) — Foreign key → users.id
- hobby — VARCHAR(64)
- INDEX — `fk_users_hobby`
messages
- messagescol — BIGINT — Primary key — NOT NULL
- num_room — BIGINT — Foreign key → chatting_rooms.room_num
- content — VARCHAR(256)
- id — VARCHAR(32)
- created_at — DATETIME(3)
- INDEX — `fk_chatting_rooms_messages`
users
- id — VARCHAR(32) — Primary key — NOT NULL
- pw — VARCHAR(128) — NOT NULL
- email — VARCHAR(64) — NOT NULL
- name — VARCHAR(32) — NOT NULL
- mbti — VARCHAR(64)
- area — VARCHAR(64)
- school — VARCHAR(64)
- introduce — VARCHAR(256)
- img_name — VARCHAR(64)
- birthday — VARCHAR(32)
- created_at — DATETIME(3)