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)