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)