umc-week2-1

Tables (10)

alarm (알람)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • is_confirmed (Field) — boolean
  • create (Field2) — datetime(6)
  • update (Field3) — datetime(6)

book (책)

  • id (Key) — bigint — Primary key — NOT NULL
  • book_category_id (Key2) — bigint — Foreign key → book_category.id — NOT NULL
  • create (Field2) — datetime(6)
  • update (Field3) — datetime(6)
  • name (Field) — varchar(40)
  • description (Field4) — text

book_category (책 카테고리)

  • id (Key) — bigint — Primary key — NOT NULL
  • create (Field2) — varchar(20)
  • update (Field3) — datetime(6)
  • name (Field) — datetime(6)

book_hashtag (책 해시태그)

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

book_like (책 호감)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • book_id (Key3) — bigint — Foreign key → book.id — NOT NULL
  • create (Field2) — datetime(6)
  • update (Field3) — datetime(6)

hashtag (해시태그)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • create (Field2) — datetime(6)
  • update (Field3) — datetime(6)

marketing (마케팅)

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

member (회원)

  • id (Key) — bigint — Primary key — NOT NULL
  • phone_num (Field) — varchar(15)
  • name (Field2) — varchar(10)
  • nickname (Field3) — varchar(20)
  • status (Field4) — varchar(15)
  • create (Field5) — datetime(6)
  • update (Field6) — datetime(6)
  • inactive_date (Field7) — datetime
  • gender (Field8) — varchar(10)

notice (공지)

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

rent (렌트)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
  • book_id (Key3) — bigint — Foreign key → book.id — NOT NULL
  • create (Field2) — datetime(6)
  • update (Field3) — datetime(6)