UMC_Week1

Tables (10)

Untitled (alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2

Untitled (marketing)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field2 (body) — text

Untitled (notice)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(30)
  • Field2 (body) — text

Untitled (hash_tag)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

book

  • Key (id) — bigint — Primary key — NOT NULL
  • id (category_id) — bigint — Foreign key → bookCategory.id — NOT NULL
  • Field (name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2

bookCategory (book_category)

  • id — bigint — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (description) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2

bookHashtag (book_hash_tag)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (book_id) — bigint — Foreign key → book.Key — NOT NULL
  • Key (hash_tag_id) — bigint — Foreign key → Untitled.Key — NOT NULL

bookLikes (book_likes)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (book_id) — bigint — Foreign key → book.Key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2

member

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (nickname) — varchar(20)
  • Field (num) — varchar(15)
  • Field (gender) — varchar(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2 (status) — varchar(15)
  • Field (inactive_date) — datetime

rent

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → member.Key — NOT NULL
  • Key (book_id) — bigint — Foreign key → book.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field2