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)