TGrow_DB

Tables (19)

BoardPermission_table (Untitled9)

  • BoardPermission_name (Key3) — varchar(5) — Primary key — NOT NULL
  • Board_id (Key4) — int — Foreign key → Board_table.Board_id — NOT NULL
  • UserType_id (Key5) — int — Foreign key → UserType_table.UserType_id — NOT NULL

Board_table (Untitled8)

  • Board_id (Key) — int — Primary key — NOT NULL
  • Board_name (Field) — varchar(50) — NOT NULL — "Free", "Team", "QnA", "Notice"

Book_table (Untitled7)

  • product_id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(50 — NOT NULL
  • author (Field2)
  • intro (Field3)
  • publisher_review (Field4) — varchar(50) — 출판사 서평
  • contents (Field5)
  • rating (Field6)
  • review_count (Field7)
  • cover_image (Field8) — varchar(255) — 책 커버 이미치 경로

CommentLike_table (Untitled17)

  • Comment_id (Key) — int — Foreign key → Comment_table.Comment_id — NOT NULL
  • User_id (Key2) — int — Foreign key → User_table.User_id — NOT NULL
  • LikeType_id (Key3) — int — Foreign key → LikeType_table.LikeType_id — NOT NULL

Comment_table (Untitled14)

  • Comment_id (Key) — int — Primary key — NOT NULL
  • User_id (Key2) — int — Foreign key → User_table.User_id — NOT NULL
  • Post_id (Key3) — int — Foreign key → Post_table.Post_id — NOT NULL
  • Comment_parentid (Field2) — int — 대댓글의 부모 댓글id
  • Comment_content (Field) — TEXT — NOT NULL
  • Comment_createdt (Field3) — DateTime — NOT NULL
  • Comment_updatedt (Field4) — DateTime — NOT NULL

CurriculumTechstack_table (Untitled4)

  • Curriculum_id (Key3) — int — Foreign key → Curriculum_table.Curriculum_id — NOT NULL
  • Techstack_id (Key) — int — Foreign key → Techstack_table.Techstack_id — NOT NULL

CurriculumUser_table (Untitled6)

  • Curriculum_id (Key3) — int — Foreign key → Curriculum_table.Curriculum_id — NOT NULL
  • User_id (Key4) — int — Foreign key → User_table.User_id — NOT NULL — 커리큘럼을 보유한 유저id

Curriculum_table (Untitled5)

  • Curriculum_id (Key) — int — Primary key — NOT NULL
  • User_id (Key2) — int — Foreign key → User_table.User_id — NOT NULL — 커리큘럼을 생성한 유저id
  • Curriculum_name (Field) — varchar(50) — NOT NULL
  • Curriculum_prompt1 (Field2) — varchar(300) — NOT NULL
  • Curriculum_prompt2 (Field3) — varchar(300) — NOT NULL — "당신의 수준을 알려주세요."의 입력
  • Curriculum_period (Field4) — DateTime — NOT NULL
  • Curriculum_result (Field5) — varchar(500) — NOT NULL — 출력 결과 커리큘럼을 문자열로 저장

LikeType_table (Untitled16)

  • LikeType_id (Key) — int — Primary key — NOT NULL
  • LikeType_name (Field) — varchar(20) — NOT NULL — "Like", "Dislike"

LoginType_table (Untitled3)

  • LoginType_id (Key) — int — Primary key — NOT NULL
  • LoginType_name (Field) — varchar(10) — "Google", "Kakao", "Local"

PostImage_table (Untitled19)

  • PostImage_id (Key2) — int — Primary key — NOT NULL
  • Post_id (Key) — int — Foreign key → Post_table.Post_id — NOT NULL
  • PostImage_image (Field) — varchar(255) — NOT NULL — 이미지 URL

PostLike_table (Untitled15)

  • Post_id (Key) — int — Foreign key → Post_table.Post_id — NOT NULL
  • User_id (Key2) — int — Foreign key → User_table.User_id — NOT NULL
  • LikeType_id (Key3) — int — Foreign key → LikeType_table.LikeType_id — NOT NULL

PostTags_table (Untitled11)

  • Post_id (Key3) — int — Foreign key → Post_table.Post_id — NOT NULL
  • Tag_id (Key4) — int — Foreign key → Tag_table.Tag_id — NOT NULL

Post_table (Untitled12)

  • Post_id (Key) — int — Primary key — NOT NULL
  • User_id (Key3) — int — Foreign key → User_table.User_id — NOT NULL
  • Board_id (Key2) — int — Foreign key → Board_table.Board_id — NOT NULL
  • Post_title (Field) — varchar(50) — NOT NULL
  • Post_content (Field2) — TEXT — NOT NULL
  • Post_viewers (Field3) — int — NOT NULL — 게시글 조회수
  • Post_likes (Field4) — int — NOT NULL — 게시글 좋아요 수
  • Post_comments (Field5) — int — NOT NULL — 게시글 댓글 수
  • Post_createdt (Field6) — DateTime — NOT NULL
  • Post_updatedt (Field7) — DateTime — NOT NULL

Scrap_table (Untitled18)

  • User_id (Key) — int — Foreign key → User_table.User_id — NOT NULL
  • Post_id (Key2) — int — Foreign key → Post_table.Post_id — NOT NULL

Tag_table (Untitled10)

  • Tag_id (Key) — int — Primary key — NOT NULL
  • Tag_name (Field) — varchar

Techstack_table (Untitled13)

  • Techstack_id (Key) — int — Primary key — NOT NULL
  • Techstack_name (Field) — varchar(50) — NOT NULL

UserType_table (Untitled)

  • UserType_id (Key) — int — Primary key — NOT NULL
  • UserType_name (Field) — varchar(10) — NOT NULL — "Admin", "User", "Member"

User_table (Untitled2)

  • User_id (Key) — int — Primary key — NOT NULL
  • UserType_id (Key2) — int — Foreign key → UserType_table.UserType_id — NOT NULL
  • LoginType_id (Key3) — int — Foreign key → LoginType_table.LoginType_id — NOT NULL
  • User_nickname (Field3) — varchar(30) — NOT NULL
  • User_email (Field4) — str — NOT NULL
  • User_password (Field5) — varchar(50)
  • User_image (Field6) — varchar(255) — 이미지 URL
  • User_createdt (Field) — DateTime — NOT NULL