TinyHome

Tables (4)

board

  • board_id — bigint — Primary key — NOT NULL
  • category_id (category_id2) — bigint — Foreign key → category.category_id — NOT NULL
  • mem_id (mem_id2) — bigint — Foreign key → member.mem_id — NOT NULL
  • category_id_category_id — bigint
  • mem_id_mem_id — bigint
  • content — varchar(255)
  • title — varchar(255)

category

  • category_id — bigint — Primary key — NOT NULL
  • category_name — varchar(255)

member

  • mem_id — bigint — Primary key — NOT NULL
  • member_age — int
  • email — varchar(255)
  • member_name — varchar(255)
  • member_pw — varchar(255) — NOT NULL

refresh_token

  • id — bigint — Primary key — NOT NULL
  • mem_id (mem_id2) — bigint — Foreign key → member.mem_id — NOT NULL
  • created_at — datetime(6)
  • expiry_date — datetime(6) — NOT NULL
  • mem_id — bigint — NOT NULL
  • token — varchar(512) — NOT NULL