calendar

Tables (5)

KEYWORD (CopyOfUntitled)

  • PK (KEYWORD_ID) — BIGINT — Primary key — NOT NULL
  • UK (NAME) — VARCHAR(100)

MEMBER (Untitled)

  • PK (MEMBER_ID) — BIGINT — Primary key — NOT NULL
  • UK (NAME) — VARCHAR(40)
  • UK (ID) — VARCHAR(20)
  • Field4 (PASSWORD) — VARCHAR(20)
  • UK (PHONE_NUM) — VARCHAR(14)

MY KEYWORD (CopyOfUntitled2)

  • PK (MY_KEYWORD_ID) — BIGINT — Primary key — NOT NULL
  • FK (MEMBER_ID) — BIGINT — Foreign key → MEMBER.PK — NOT NULL
  • PK (KEYWORD_ID) — BIGINT — Foreign key → KEYWORD.PK — NOT NULL

POST (CopyOfCopyOfCopyOfUntitled)

  • PK (POST_ID) — BIGINT — Primary key — NOT NULL
  • PK (POST_AUTHOR_ID) — BIGINT — Primary key — NOT NULL
  • PK (POST_KEYWORD_ID) — BIGINT — Foreign key → POST_KEYWORD.PK — NOT NULL
  • PK (MEMBER_ID) — BIGINT — Foreign key → MEMBER.PK — NOT NULL
  • FK (POST_KEYWORD) — VARCHAR(100)
  • FK (POST_TITLE) — VARCHAR(200)
  • FK (POST_CONTENT) — VARCHAR(500)
  • FK (POST_AUTHOR_NAME) — VARCHAR(100)
  • FK (DATE) — DATE
  • FK (UPDATE DATE) — DATE

POST_KEYWORD (CopyOfCopyOfUntitled)

  • PK (POST_KEYWORD_ID) — BIGINT — Primary key — NOT NULL
  • PK (KEYWORD_ID) — BIGINT — Foreign key → KEYWORD.PK — NOT NULL
  • FK (POST_ID) — BIGINT