highton
Tables (4)
posts (게시물 테이블)
- pid (Key) — LONG — Primary key — NOT NULL
- uid (Key2) — LONG — Foreign key → users.uid — NOT NULL
- title (Field) — VARCHAR(20)
- content (Field2) — VARCHAR(15000)
- time_stamp (Field3) — DATE
- image (Field4) — VARCHAR(1000)
- like (Field5) — INT
prefer_tag (태그연결)
- pid (Key) — LONG — Foreign key → posts.pid — NOT NULL
- tid (Key2) — LONG — Foreign key → tag.tid — NOT NULL
tag (태그)
- tid (Key) — LONG — Primary key — NOT NULL
- tagname (Field)
users (사용자 테이블)
- uid (Key) — LONG — Primary key — NOT NULL
- id (Field) — VARCHAR(20)
- psword (Field2) — VARCHAR(20)