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