ricanica

Tables (4)

Icon (Untitled4)

  • icon_id (아이콘) — BiGINT — Primary key — NOT NULL
  • member_id (아이디) — VARCHAR(30) — Foreign key → Member.member_id — NOT NULL
  • icon_type (아이콘타입) — BIGINT

Letter (Untitled2)

  • letter_id (편지아이디) — BIGINT — Primary key — NOT NULL
  • member_id (아이디2) — VARCHAR(30) — Foreign key → Member.member_id — NOT NULL
  • content (내용) — TEXT
  • writer (Field2)
  • created_at (작성일자) — BIGINT

Member (Untitled)

  • member_id (아이디) — VARCHAR(30) — Primary key — NOT NULL
  • password (비밀번호) — VARCHAR(30)
  • nicknames (닉네임) — VARCHAR(30)

Vote (Untitled3)

  • vote_id (투표아이디) — BIGINT — Primary key — NOT NULL
  • question_type (질문타입) — BIGINT
  • member_id (투표대상자) — VARCHAR(50)