mmmt

Tables (6)

Comment

  • id_comment (Key) — Primary key — NOT NULL
  • content (Filed) — String — NOT NULL

Member

  • id_member (Key) — Long — Primary key — NOT NULL
  • memberid (Field) — String — NOT NULL
  • password (Field2) — Stirng — NOT NULL
  • profileimage (Field3) — Image
  • nickname (Field4) — Stiring
  • tag (Field5) — Stirng

Mypost

  • id_mypost (Long) — Long — Primary key — NOT NULL
  • done (Field) — int
  • money (Field2) — int
  • time (Field3) — String — NOT NULL
  • image (Field4) — Image — NOT NULL
  • content (Field5) — String — NOT NULL
  • title (Field6) — String — NOT NULL
  • id_member (Key) — Long — Foreign key → Member.id_member — NOT NULL

Post

  • id_post (Long) — Long — Primary key — NOT NULL
  • heart (Field) — int
  • amount (Field2) — int
  • comment (Filed3) — List — NOT NULL
  • address (Field4) — String
  • time (Filed5) — String — NOT NULL
  • image (Filed6) — Image — NOT NULL
  • content (Filed7) — String — NOT NULL
  • title (Filed8) — String — NOT NULL
  • viewcount (Field9) — int
  • id_member (Key3) — Long — Foreign key → Member.id_member — NOT NULL
  • id_comment (Key4) — Foreign key → Comment.id_comment — NOT NULL
  • report (Field3) — int
  • tag (Field5) — String

Story

  • Id_story (Key) — Long — Primary key — NOT NULL
  • videourl (Field2) — video — NOT NULL

heart

  • id_heart (Key) — Primary key — NOT NULL
  • memberid (Field2)
  • id_post (Long) — Long — Foreign key → Post.id_post — NOT NULL