semi-project

Tables (12)

Comments (Untitled4)

  • comments_No (Key) — Number — Primary key — NOT NULL
  • written_date (Field3) — date
  • modified_date (Field4) — date
  • comments content (Field5) — varchar2(1000)
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL
  • review_no (Key3) — Number — Foreign key → Reviews.review_no — NOT NULL

Deleted_comments (CopyOfUntitled4)

  • customer_no (Field2) — Number
  • written_date (Field3) — date
  • modified_date (Field4) — date
  • comments content (Field5) — varchar2(1000)
  • comments_No (Key2) — Number — Foreign key → Comments.comments_No — NOT NULL

Deleted_review (CopyOfUntitled3)

  • customer_no (Field3) — Number
  • review title (Field4) — varchar(20)
  • review_content (Field5) — varchar2(1000)
  • written_date (Field6) — date
  • modified_date (Field7) — date
  • like_cnt (Field) — Number
  • hotel_ID (Field2) — varchar2(50)
  • read_cnt (Field9) — Number
  • dislike_cnt (Field10) — Number
  • read_cnt (Field11) — Number
  • review_no (Key2) — Number — Foreign key → Reviews.review_no — NOT NULL

Payment (Untitled7)

  • Payment_no (Key) — Number — Primary key — NOT NULL
  • amount (Field2) — number
  • paid date (Field3) — Date
  • Unnpaid_date (Field4) — Date
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

Quit_users (CopyOfUntitled)

  • email (Field) — varchar2(50)
  • name (Field2) — varchar(20)
  • phone (Field4) — varchar2(13)
  • enrolldate (Field5) — Date
  • QuitDate (Field7) — Date
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

Reviews (Untitled3)

  • review_no (Key) — Number — Primary key — NOT NULL
  • review_rate (Field3) — number
  • review title (Field4) — varchar(20)
  • review_content (Field5) — varchar2(1000)
  • written_date (Field6) — date
  • modified_date (Field7) — date
  • like_cnt (Field) — Number
  • hotel_ID (Field2) — varchar2(50)
  • rate_total (Field8) — Number
  • read_cnt (Field9) — Number
  • dislike_cnt (Field10) — Number
  • Rate_cnt (Field11) — Number
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

Users (Untitled)

  • customer_no (Key) — Number — Primary key — NOT NULL
  • email (Field) — varchar2(50)
  • name (Field2) — varchar(20)
  • password (Field3) — varchar2(100)
  • phone (Field4) — varchar2(13)
  • enrolldate (Field5) — Date
  • originalFile (Field6) — varchar2(200)
  • QuitDate (Field7) — Date
  • status (Field8) — varchar2(9)
  • renamedfile (Field9) — varchar2(200)

ads (CopyOfUntitled32)

  • ads_no (Key) — Number — Primary key — NOT NULL
  • ads_rate (Field3) — number
  • rate_total (Field8) — Number
  • Ads title (Field4) — varchar(20)
  • Ads_content (Field5) — varchar2(1000)
  • written_date (Field6) — date
  • modified_date (Field7) — date
  • like_cnt (Field) — Number
  • dislike_cnt (Field10) — Number
  • read_cnt (Field9) — Number
  • Rate_cnt (Field11) — Number
  • facilities (Field2) — varchar2(500)
  • searched_address (Field13) — varchar2(500)
  • detailed_address (Field14) — varchar2(500)
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

ads_comments (CopyOfUntitled42)

  • Ads_comments_No (Key) — Number — Primary key — NOT NULL
  • written_date (Field3) — date
  • modified_date (Field4) — date
  • ads_comments content (Field5) — varchar2(1000)
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL
  • ads_no (Key3) — Number — Foreign key → ads.ads_no — NOT NULL

tbl_dislike (CopyOfCopyOfUntitled62)

  • reviewNo (Key) — Number — Primary key — NOT NULL
  • ads_no (Field) — Number
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

tbl_like (CopyOfCopyOfUntitled6)

  • reviewNo (Key) — Number — Primary key — NOT NULL
  • ads_no (Field) — Number
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL

tbl_rate (CopyOfUntitled6)

  • reviewNo (Key) — Number — Primary key — NOT NULL
  • ads_no (Field) — Number
  • customer_no (Key2) — Number — Foreign key → Users.customer_no — NOT NULL