Final_Project_MonStu

테이블 (11)

ExceptionLog (에러 로그) (Untitled11)

  • id (로그 아이디) — bigint — 기본 키 — NOT NULL
  • line_num (Field6) — int
  • created_time (Field) — datetime
  • class_name (Field4) — varchar
  • exception_type (Field7) — varchar
  • http_status (Field11) — varchar
  • message (Field8) — text
  • method_name (Field5) — varchar
  • request_url (Field10) — varchar(1024)
  • service (Field3) — varchar
  • level (Field2) — enum

History (단어,문장) MongoDB에 위치 (Untitled9)

  • id (Key) — string — 기본 키 — NOT NULL
  • genre (Field2) — enum
  • original_text (Field) — varchar
  • translated_text (Field3) — enum
  • source_lang (Field4) — enum
  • target_lang (Field5) — enum

Image (이미지 파일 저장소) (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field6) — varchar
  • url (Field5) — varchar
  • type (Field) — varchar
  • byte_size (Field2) — bigint
  • height (Field3) — int
  • width (Field4) — int

Member (회원) (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field4) — date
  • updated_at (Field5) — date
  • email (Field3) — varchar
  • nick_name (Field2) — varchar
  • password (Field) — varchar
  • phone_number (Field8) — varchar
  • countryCode (Field6) — enum
  • role (Field7) — enum
  • status (A) — enum

Member_log (회원 로그) (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → Member (회원).id — NOT NULL
  • failed_login_count (Field2) — tinyint
  • failed_login_time (Field4) — date
  • last_Login (Field3) — date

Nouncement (공지사항) (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field6) — varchar
  • content (Field) — text
  • created_at (Field2) — datetime
  • modified_at (Field4) — datetime
  • is_public (Field3) — boolean
  • is_important (Field5) — boolean
  • view_count (Field7) — int

Post (게시물) (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • author_id (Key2) — bigint — 외래 키 → Member (회원).id — NOT NULL
  • thumnail_id (Key3) — bigint — 외래 키 → Image (이미지 파일 저장소).id — NOT NULL
  • created_at (Field4) — date
  • modified_at (Field5) — date
  • title (Field2) — varchar
  • content (Field) — text
  • is_public (Field3) — boolean

Verifi_code (코드 검증) (Untitled13)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • email (Field6) — varchhar
  • code (Field) — varchar
  • created_at (Field2) — timestamp
  • expires_at (Field3) — timestamp
  • verified (Field4) — boolean
  • faild_count (Field5) — tinyint
  • faild_at (Field7) — timestamp

nouncement_image (Untitled12)

  • id (Key3) — bigint — 기본 키 — NOT NULL
  • image_id (Key) — bigint — 외래 키 → Image (이미지 파일 저장소).id — NOT NULL
  • nouncement_id (Key2) — bigint — 외래 키 → Nouncement (공지사항).id — NOT NULL

post_history (Untitled4)

  • history_id (Key3) — bigint — 기본 키 — NOT NULL
  • post_id (Key) — bigint — 외래 키 → Post (게시물).id — NOT NULL

post_log (게시글 로그) (Untitled6)

  • post_id (Key) — bigint — 외래 키 → Post (게시물).id — NOT NULL
  • view_count (Field) — int
  • last_viewed_at (Field2) — datetime