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