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