hell
Tables (13)
Admin
- admin_ID (Key) — varchar2(50) — Primary key — NOT NULL
- admin_PW (Field2) — varchar2(50)
- admin_Name (Field3) — varchar2(30)
- admin_Phone (Field4) — varchar2(60)
- admin_Email (Field5) — varchar2(30)
- admin_Department (Field) — varchar2(30)
- admin_Title (Field6) — varchar2(30)
AdminMessage (Untitled10)
- adminMessage_Seq (Key) — number(7) — Primary key — NOT NULL
- admin_ID (Key2) — varchar2(50) — Foreign key → Admin.admin_ID — NOT NULL
- adminMessage_Content (Field) — varchar2(3000)
- adminMessage_Indate (Field2) — date
- admin_Name (Field3) — varchar2(30)
AdminTODO (Untitled7)
- adminTodo_Seq (Key) — number(7) — Primary key — NOT NULL
- admin_ID (Key2) — varchar2(50) — Foreign key → Admin.admin_ID — NOT NULL
- adminTodo_Content (Field) — varchar2(1000)
- adminTodo_Indate (Field2) — date
Bookmark (CopyOfUntitled4)
- bookmark_Seq (Key9) — number(7) — Primary key — NOT NULL
- enterprise_ID (Key2) — varchar2(50) — Foreign key → Enterprise.enterprise_ID — NOT NULL
- customer_ID (Key) — varchar2(50) — Foreign key → Customer.customer_ID — NOT NULL
- forSale_Seq (Key3) — number(7) — Foreign key → ForSale.forSale_Seq — NOT NULL
- bookmark_Indate (Field) — date
Customer (Untitled)
- customer_ID (Key) — varchar2(50) — Primary key — NOT NULL
- customer_PW (Field) — varchar2(50)
- customer_Name (Field2) — varchar2(30)
- customer_BirthDate (Field5) — varchar2(20)
- customer_Phone (Field7) — varchar2(60)
- customer_Gender (Field8) — varchar2(3)
- customer_Email (Field9) — varchar2(30)
- customer_Indate (Field4) — date
CustomerBoard (Untitled2)
- customerBoard_Seq (Key) — number(7) — Primary key — NOT NULL
- customer_ID (Key2) — varchar2(50) — Foreign key → Customer.customer_ID — NOT NULL
- customerBoard_Title (Field2) — varchar2(50)
- customerBoard_Content (Field) — varchar2(3000)
- customerBoard_Indate (Field3) — date
- customerBoard_HitCount (Field6) — number(5)
CustomerComment (Untitled8)
- customerComment_Seq (Key) — Primary key — NOT NULL
- customerBoard_Seq (Key2) — number(7) — Foreign key → CustomerBoard.customerBoard_Seq — NOT NULL
- customer_ID (Field) — varchar2(50)
- customerComment_Indate (Field2) — date
- customerComment_Content (Field3) — varchar2(3000)
Enterprise (Untitled3)
- enterprise_ID (Key) — varchar2(50) — Primary key — NOT NULL
- enterprise_PW (Field) — varchar2(50)
- enterprise_Name (Field2) — varchar2(100)
- enterprise_Address (Field3) — varchar2(150)
- enterprise_RegiNum (Field4) — varchar2(100)
- enterprise_ManagerName (Field5) — varchar2(30)
- enterprise_ManagerPhone (Field6) — varchar2(30)
- enterprise_ManagerEmail (Field7) — varchar2(30)
- enterprise_ETC (Field9) — varchar2(3000)
- enterprise_Code (Field10) — varchar2(30)
- enterprise_Indate (Field8) — date
- enterprise_Permission (Field11) — varchar2(5)
EnterpriseBoard (Untitled6)
- enterpriseBoard_Seq (Key) — number(7) — Primary key — NOT NULL
- enterprise_ID (Key2) — varchar2(50) — Foreign key → Enterprise.enterprise_ID — NOT NULL
- enterpriseBoard_Title (Field2) — varchar2(50)
- enterpriseBoard_Content (Field3) — varchar2(3000)
- enterpriseBoard_indate (Field4) — date
- enterpriseBoard_HitCount (Field6) — number(5)
- enterpriseBoard_AdminCheck (Field) — varchar2(3)
EnterpriseComment (Untitled9)
- enterpriseComment_Seq (Key) — number(7) — Primary key — NOT NULL
- enterpriseBoard_Seq (Key2) — number(7) — Foreign key → EnterpriseBoard.enterpriseBoard_Seq — NOT NULL
- enterprise_ID (Field) — varchar2(50)
- entperpriseComment_Indate (Field2) — date
- enterpriseComment_Content (Field3) — varchar2(3000)
ForSale (Untitled5)
- forSale_Seq (Key) — number(7) — Primary key — NOT NULL
- enterprise_ID (Key2) — varchar2(50) — Foreign key → Enterprise.enterprise_ID — NOT NULL
- geoapi_prefectures (Field) — varchar2(3000)
- geoapi_cities (Field2) — varchar2(3000)
- geoapi_towns (Field3) — varchar2(3000)
- geoapi_remain (Field4) — varchar2(3000)
- forSale_Title (Field5) — varchar2(300)
- forSale_Rent (Field6) — number(10)
- forSale_Deposit (Field7) — number(10)
- forSale_Reward (Field8) — number(10)
- forSale_ManageCost (Field9) — number(7)
- forSale_Option (Field10) — varchar2(1000)
- forSale_ETC (Field11) — varchar2(3000)
- forSale_Indate (Field12) — date
- forSale_PostCode (Field13) — varchar2(100)
- forSale_HouseType (Field14) — varchar2(300)
- forSale_Status (Field15) — varchar2(300)
- forSale_Lat (Field16) — number(7,10)
- forSale_Lng (Field17) — number(7,10)
- forSale_Subway (Field18) — varchar2(90)
- forSale_SubwayDistance (Field19) — number(7)
- forSale_SubwayDistance2 (Field20) — varchar2(900)
- forSale_HitCount (Field21) — number(7)
- forSale_Trade (Field22) — varchar2(10)
- forSale_TradeIndate (Field23) — date
- forSale_TradeCustomer (Field24) — varchar2(100)
Reservation (Untitled4)
- reservation_Seq (Key9) — number(7) — Primary key — NOT NULL
- enterprise_ID (Key2) — varchar2(50) — Foreign key → Enterprise.enterprise_ID — NOT NULL
- customer_ID (Key) — varchar2(50) — Foreign key → Customer.customer_ID — NOT NULL
- forSale_Seq (Key3) — number(7) — Foreign key → ForSale.forSale_Seq — NOT NULL
- reservation_Visa (Field) — varchar2(50)
- reservation_Guarantor (Field2) — varchar2(1)
- reservation_Indate (Field3) — date
- reservation_Complete (Field4) — varchar2(3)
image (Untitled11)
- image_Seq (Key) — number(7) — Primary key — NOT NULL
- forSale_Seq (Key2) — number(7) — Foreign key → ForSale.forSale_Seq — NOT NULL
- originName (Field2) — varchar2(1000)
- saveName (Field3) — varchar2(1000)