birdview

Tables (3)

article (게시글)

  • article_seq (식별자) — BIGINTEGER — Primary key — NOT NULL
  • user_seq (식별자2) — BIGINT — Foreign key → user.user_seq — NOT NULL
  • article_title (제목) — VARCHAR(100) — NOT NULL
  • article_content (내용) — LOB — NOT NULL

picture (사진)

  • picture_seq (식별자) — BIGINTEGER — Primary key — NOT NULL
  • article_seq (식별자2) — BIGINTEGER — Foreign key → article.article_seq — NOT NULL
  • picture_origin_name (원본 파일 이름) — VARCHAR(50) — NOT NULL
  • picture_saved_name (저장된 파일 이름) — VARCHAR(50) — NOT NULL

user (회원)

  • user_seq (식별자) — BIGINT — Primary key — NOT NULL
  • user_email (이메일) — VARCHAR(50) — NOT NULL
  • user_password (비밀번호) — VARCHAR(50) — NOT NULL