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)