PJT1 - 1

Tables (10)

feed

  • feed_id — INT — Primary key — NOT NULL — member과 매핑하기 위한 도구
  • content — TEXT
  • picture — BLOB
  • like — INT
  • create — DATETIME — NOT NULL
  • modify — DATETIME — NOT NULL

feed_comment

  • feed_id — INT — Foreign key → feed.feed_id — NOT NULL — member과 매핑하기 위한 도구
  • Key — Foreign key → member.member_seq — NOT NULL
  • content — TEXT
  • modify_date — DATETIME — NOT NULL
  • create_date — DATETIME

follow

  • Key — Foreign key → member.member_seq — NOT NULL
  • Key (Key2) — Foreign key → member.member_seq — NOT NULL

machine

  • obj_id — INT — Primary key — NOT NULL
  • picture — BLOB — NOT NULL
  • post — BLOB — NOT NULL
  • video — BLOB — NOT NULL
  • create_date — DATETIME — NOT NULL

member

  • member_seq — int — Primary key — NOT NULL
  • id — VARCHAR(20)
  • password — VARCHAR(20) — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • nickname — VARCHAR(15) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • address_base — VARCHAR(255)
  • address_spec — VARCHAR(255)
  • memo — TEXT

member-feed

  • id (id2) — INT — Foreign key → feed.feed_id — NOT NULL — member과 매핑하기 위한 도구
  • Key — Foreign key → member.member_seq — NOT NULL

mypage

  • Key — Foreign key → member.member_seq — NOT NULL
  • Field

notice

  • id — INT — Primary key — NOT NULL
  • title — varchar(63)
  • content — text
  • picture — BLOB
  • create_date — DATETIME
  • modify_date — DATETIME — NOT NULL
  • hit — INT
  • Key — Foreign key → member.member_seq — NOT NULL

notice_comment (notice_coment)

  • id (id2) — INT — Foreign key → notice.id — NOT NULL
  • Key — Foreign key → member.member_seq — NOT NULL
  • content — TEXT
  • modify_date — DATETIME — NOT NULL
  • create_date — DATETIME

record

  • Key — Foreign key → member.member_seq — NOT NULL
  • picture — BLOB — NOT NULL
  • post — BLOB — NOT NULL
  • video — BLOB — NOT NULL
  • create_date — DATETIME — NOT NULL
  • download_data — DATETIME