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