GOP
Tables (6)
Cat (백과사전 - 고양이)
- cat_id (PK) — NUMBER — Primary key — NOT NULL
- cat_description (Field) — VARCHAR2(100)
Comment (커뮤니티 - 댓글)
- comment_id (PK) — NUMBER — Primary key — NOT NULL
- comment_content (Field) — VARCHAR2(100)
- comment_author (Field2) — VARCHAR2(40)
- comment_createdAt (Field3) — DATETIME
- post_id (FK) — NUMBER
- post_id (PK2) — NUMBER — Foreign key → Post.post_id — NOT NULL
Dog (백과사전 - 강아지)
- dog_id (PK) — NUMBER — Primary key — NOT NULL
- dog_description (Field) — VARCHAR2(100)
Member (회원)
- member_id (PK) — NUMBER — Primary key — NOT NULL
- member_name (Field) — VARCHAR2(20)
- member_email (Field2) — VARCHAR2(40)
- member_password (Field3) — VARCHAR2(40)
- member_role (Field4) — VARCHAR2(20)
- member_createdAt (Field5) — DATETIME
Missing (실종동물)
- missing_id (PK) — NUMBER — Primary key — NOT NULL
- missing_name (Field) — VARCHAR2(30)
- missing_species (Field2) — VARCHAR2(20)
- missing_description (Field3) — VARCHAR2(100)
- missing_contact (Field4) — VARCHAR2(20)
- missing_photo (Field5) — BLOB
- missing_createdAt (Field6) — DATETIME
Post (커뮤니티 - 게시물)
- post_id (PK) — NUMBER — Primary key — NOT NULL
- post_title (Field) — VARCHAR2(40)
- post_content (Field2) — VARCHAR2(300)
- post_author (Field3) — VARCHAR2(40)
- post_createdAt (Field4) — DATETIME
- post_views (Field5) — NUMBER
- post_comments (Field6) — NUMBER
- post_photo (Field7) — VARCHAR2(30)