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)