ERD_1_ver02

Tables (10)

comment

  • comment_seq — INT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • modify_time — TIMESTAMP — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • feed_seq — INT — Foreign key → feed.feed_seq
  • member_seq — INT — Foreign key → member.member_seq — NOT NULL

connect

  • connect_seq — INT — Primary key — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • follower — INT — Foreign key → member.member_seq — NOT NULL
  • following — INT — Foreign key → member.member_seq — NOT NULL

feed

  • feed_seq — INT — Primary key — NOT NULL
  • member_seq — INT — Foreign key → member.member_seq
  • content — TEXT
  • post — VARCHAR(255)
  • like — INT — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • modify_time — TIMESTAMP — NOT NULL

heart (Untitled)

  • heart_seq (hearat_seq) — INT — Primary key — NOT NULL
  • member_seq — INT — Foreign key → member.member_seq — NOT NULL
  • feed_seq — INT — Foreign key → feed.feed_seq — NOT NULL

machine

  • machine_seq — INT — Primary key — NOT NULL
  • recent_time — TIMESTAMP — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • loc_seq — INT — Foreign key → machine_location.loc_seq — NOT NULL

machine_data

  • machine_data_seq — INT — Primary key — NOT NULL
  • photo — VARCHAR(255) — NOT NULL
  • post — VARCHAR(255) — NOT NULL
  • video — VARCHAR(255)
  • voice — VARCHAR(255)
  • create_time — TIMESTAMP — NOT NULL
  • machine_seq — INT — Foreign key → machine.machine_seq — NOT NULL

machine_location

  • loc_seq — INT — Primary key — NOT NULL
  • city — VARCHAR(63) — NOT NULL
  • name — VARCHAR(63) — NOT NULL

member

  • member_seq — INT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(45) — NOT NULL
  • addr_base — VARCHAR(255)
  • addr_spec — VARCHAR(255)
  • member_profile — VARCHAR(255)
  • member_state — VARCHAR(255)
  • create_time — TIMESTAMP — NOT NULL
  • modify_time — TIMESTAMP — NOT NULL
  • is_admin — CHAR(1) — NOT NULL

notice

  • notice_seq — INT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • create_seq — INT — Foreign key → member.member_seq
  • modify_time — TIMESTAMP — NOT NULL
  • modify_seq — INT — NOT NULL
  • hit — INT — NOT NULL

store

  • store_seq — INT — Primary key — NOT NULL
  • photo — VARCHAR(255) — NOT NULL
  • video — VARCHAR(255)
  • post — VARCHAR(255) — NOT NULL
  • voice — VARCHAR(255)
  • create_time — TIMESTAMP — NOT NULL
  • create_seq — INT — Foreign key → member.member_seq — NOT NULL
  • recent_time — TIMESTAMP — NOT NULL
  • recent_seq — INT — NOT NULL