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