헐레벌똥

테이블 (10)

Untitled (Restroom_Info)

  • Key (Restroom_Id(FK)) — INT PRIMARY KEY — 외래 키 → re.Key — NOT NULL
  • Field (화장실명) — varchar2(10)
  • Field2 (도로명주소) — varchar2(15)
  • Field3 (관리기관명) — varchar2(10)
  • Field4 (연락처) — varchar2(11)
  • Field5 (남녀구분) — varchar2(2)
  • Field6 (장애인) — varchar2(2)
  • Field7 (기저귀) — varchar2(2)
  • Field8 (개방기간) — varchar2(15)

Untitled (Restroom_Review)

  • Key2 (Review_Id(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key (Restroom_Id(FK)) — INT PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key2 (Userid(FK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(FK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (평점) — varchar2(3)
  • Field3 (리뷰사진) — varchar2(5)
  • Field4 (작성시각) — varchar2(20)
  • Field5 (수정시각) — varchar2(20)
  • Field6 (추천수) — varchar2(3)
  • Field7 (댓글수) — varchar2(3)

Untitled (Members)

  • Key (Members_seq(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Userid(PK)) — varchar2(10) — 기본 키 — NOT NULL
  • Key (Nickname(PK)) — varchar2(10) — 기본 키 — NOT NULL
  • Field (타입(일반/관리자)) — varchar2(3)
  • Field3 (비밀번호) — varchar2(10)
  • Field4 (성별) — varchar(2)
  • Field5 (이메일) — varchar2(25)
  • Field6 (가입날짜) — varchar2(10)
  • Field (신고누적횟수) — Num(5)

Untitled (Members_FindPW)

  • Key2 (Userid(FK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Field (이메일) — varchar2(25)
  • Field2 (임시PW) — varchar2(10)

Untitled (Question)

  • Key (Question_Id(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Userid(FK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(FK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (구분(일반/공지)) — varchar2(2)
  • Field2 (제목) — varchar2(20)
  • Field4 (작성시각) — varchar2(20)
  • Field5 (수정시각) — varchar2(20)
  • Field7 (조회수) — varchar2(10)

Untitled (Comment)

  • Key (Question_id(FK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Comment_id(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Userid(PK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(PK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (구분(일반[0]/채택[1])) — varchar2(3)
  • Field2 (작성시각) — varchar2(20)
  • Field3 (수정시각) — varchar2(20)
  • Field5 (내용) — varchar2(50)

Untitled (ReComment)

  • Key (Question_Id(FK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Comment_Id(FK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key3 (ReComment_Id(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key2 (Userid(PK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(PK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (구분(일반[0],채택[1])) — varchar2(3)
  • Field2 (작성시각) — varchar2(20)
  • Field3 (수정시각) — varchar2(20)
  • Field5 (내용) — varchar2(30)

Untitled (Report)

  • Key (Question_id(FK)) — INT PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key2 (Comment_id(FK)) — INT PRIMARY KEY — 외래 키 → Untitled.Key2 — NOT NULL
  • Key2 (Userid(FK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(FK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Report_Id(seq)) — INT
  • Field2 (신고유형) — varcahr2(5)
  • Field8 (사유타입) — varchar2(30)
  • Field9 (기타내용) — varchar2(30)
  • Field10 (작성시각) — varchar2(20)
  • Field11 (수정시각) — varchar2(20)
  • Field12 (신고자아이디) — varchar2(10)
  • Field13 (처리여부) — varchar2(4)

Untitled (Report_Restroom)

  • Key2 (Review_Id(FK)) — INT PRIMARY KEY — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Restroom_Id(FK)) — INT PRIMARY KEY — 외래 키 → Untitled.Key — NOT NULL
  • Key2 (Userid(FK)) — varchar2(10) — 외래 키 → Untitled.Key2 — NOT NULL
  • Key (Nickname(FK)) — varchar2(10) — 외래 키 → Untitled.Key — NOT NULL
  • Field (Report_Id(seq)) — INT
  • Field3 (내용) — varchar2(30)
  • Field4 (신고자아이디) — varchar2(10)
  • Field5 (신고시각) — varchar2(20)
  • Field6 (처리여부) — varchar2(4)

re (Restroom_Location)

  • Key (Restroom_Id(PK)) — INT PRIMARY KEY — 기본 키 — NOT NULL
  • Key (화장실명(PK)) — varchar2(10) PRIMARY KEY — 기본 키 — NOT NULL
  • Key (위도(PK)) — varchar2(10) PRIMARY KEY — 기본 키 — NOT NULL
  • Key (경도(PK)) — varchar2(10) PRIMARY KEY — 기본 키 — NOT NULL
  • Field (지역) — varchar2(4)
  • Field (도로명 주소) — varchar2(15)