COTL

Tables (6)

Item (아이템)

  • Key — Primary key — NOT NULL
  • bookmark_id (Key2) — BIGINT — Foreign key → bookmark.bookmark_id — NOT NULL

bookmark (북마크)

  • bookmark_id (Key) — BIGINT — Primary key — NOT NULL
  • Field

bookmark_post (북마크_게시물)

  • Key — Primary key — NOT NULL
  • bookmark_id (Key2) — BIGINT — Foreign key → bookmark.bookmark_id — NOT NULL
  • post_id (Key3) — BIGINT — Foreign key → post.post_id — NOT NULL
  • type (Field)

post (게시물)

  • post_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL — 유저 PK
  • Field

user (유저)

  • user_id (Key) — BIGINT — Primary key — NOT NULL — 유저 PK
  • identifier (Field) — VARCHAR — NOT NULL
  • password (Field2) — VARCHAR — NOT NULL
  • role (Field3) — VARCHAR — NOT NULL
  • gender (Field4) — VARCHAR — NOT NULL
  • age (Field5) — BIGINT — NOT NULL
  • phone (Field6) — CHAR(11)
  • nickname (Field7) — VARCHAR
  • created_at (Field8) — DATE — NOT NULL
  • deleted_date (Field9) — DATE
  • stature (Field10) — BIGINT — NOT NULL
  • weight (Field11) — BIGINT — NOT NULL

user_follow (유저_팔로우)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL — 유저 PK
  • bookmark_id (Key3) — BIGINT — Foreign key → bookmark.bookmark_id — NOT NULL
  • type (Field)