GoT 0308
Tables (15)
Got_Mbti_Category (Untitled)
- mbti_Category_no (Key) — NUMBER — Primary key — NOT NULL
- mbti_Category_name (Field) — VARCHAR2(8)
Untitled (Got_user)
- Key (user_no) — NUMBER — Primary key — NOT NULL
- mbti_Category_no (Key) — NUMBER — Foreign key → Got_Mbti_Category.mbti_Category_no — NOT NULL
- userCategory_no (Key2) — NUMBER — Foreign key → Untitled2.userCategory_no — NOT NULL
- Field (user_id) — VARCHAR2(20)
- Field2 (user_pw) — VARCHAR2(24)
- Field3 (user_name) — VARCHAR2(10)
- Field (user_nick) — VARCHAR2(20)
- Field (user_joinDate) — DATE
- Field (user_confirm) — VARCHAR2(2)
Untitled (Got_preferenceCategory)
- Key (preferenceCategory_no) — NUMBER — Primary key — NOT NULL
- Field (preferenceCategory_name) — VARCHAR2(20)
Untitled (Got_userPreference)
- Key (userPreference_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (preferenceCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
Untitled (Got_userGrade)
- Key (userGrade_no) — NUMBER — Primary key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (gradeCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (userGrade_userPoint) — NUMBER
Untitled (Got_board)
- Key (board_no) — NUMBER — Primary key — NOT NULL
- Key (boardCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (board_title) — VARCHAR2(60)
- Field (board_content) — VARCHAR2(2000)
- Field (board_witeDate) — DATE
- Field (board_readCount) — NUMBER
- Field (board_likeCount) — NUMBER
- Field (board_score) — NUMBER
- Field (board_state) — VARCHAR2(2)
Untitled (Got_boardCategory)
- Key (boardCategory_no) — NUMBER — Primary key — NOT NULL
- Field (boardCategory_name) — VARCHAR2(20)
Untitled (Got_locationCategory)
- Key (locationCategory_no) — NUMBER — Primary key — NOT NULL
- Key (boardCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (locationCategory_name) — VARCHAR2(20)
Untitled (Got_comment)
- Key (comment_no) — NUMBER — Primary key — NOT NULL
- Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (comment_content) — VARHCAR2(1000)
- Field (comment_writedate) — DATE
- Field (comment_state) — VARCHAR(2)
Untitled (Got_report)
- Key (report_no) — NUMBER — Primary key — NOT NULL
- Key (boardCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (comment_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (user_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (report_content) — VARCHAR(1000)
- Field (report_date) — DATE
- Field (report_state) — VARCHAR2(2)
- Field (report_repoter) — NUMBER
Untitled (Got_gradeCategory)
- Key (gradeCategory_no) — NUMBER — Primary key — NOT NULL
- Field (gradeCategory_name) — VARCHAR2(20)
- Field (gradeCategory_minPoint) — NUMBER
Untitled (Got_boardImage)
- Key (boardImage_no) — NUMBER — Primary key — NOT NULL
- Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (boardImage_url) — VARCHAR2(500)
- Field (boardImage_name) — VARCHAR2(100)
Untitled2 (Got_userCategory)
- userCategory_no (Key) — NUMBER — Primary key — NOT NULL
- userCategory_name (Field) — VARCHAR2(20)
Untitled2 (Got_lodgingReportCategory)
- Key (lodgingReportCategory_no) — NUMBER — Primary key — NOT NULL
- Key (boardCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (lodgingReportCategory_name) — VARCHAR2(20)
Untitled3 (Got_locationReportCategory)
- Key (locationReportCategory_no) — NUMBER — Primary key — NOT NULL
- Key (boardCategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Field (locationReportCategory_name) — VARCHAR2(20)