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)