yis_ojt

Tables (5)

biz_talk_reservation (Untitled)

  • id — Primary key — NOT NULL
  • date (Field)
  • pushDate (Field2)
  • sendDate (Field3)
  • user (Field4)
  • userHp (Field5)
  • isSend (Field6)

s_domains

  • id — int — Primary key — NOT NULL — 도메인식별자
  • host — varchar(80) — NOT NULL — 도메인주소
  • type — enum('free','premium') — NOT NULL — 무료/유료
  • clientSecret — char(36) — NOT NULL — 고객비밀키
  • createdAt — datetime — NOT NULL — 생성일자
  • updatedAt — datetime — NOT NULL — 수정일자
  • deletedAt — datetime — 삭제일자
  • UserId — int — Foreign key → s_users.id — NOT NULL — 회원식별자

s_posts

  • id — int(11) — Primary key — NOT NULL — 예약게시글 식별자
  • startTime — varchar(50) — NOT NULL — 시작시간
  • endTime — varchar(50) — NOT NULL — 종료시간
  • bookDate — varchar(50) — NOT NULL — 예약일
  • createdAt — datetime — NOT NULL — 생성일시
  • updatedAt — datetime — NOT NULL — 수정일시
  • UserId — int — Foreign key → s_users.id — NOT NULL — 회원식별자
  • meetingRoom_no (meetingRoom_no2) — int(11) — Foreign key → s_schedules.meetingRoom_no — NOT NULL — 회의실번호

s_schedules

  • meetingRoom_no — int(11) — Primary key — NOT NULL — 회의실번호
  • meetingRoom — varchar(50) — NOT NULL — 회의실이름

s_users

  • id — int — Primary key — NOT NULL — 회원식별자
  • email — varchar(40) — NOT NULL — 회원이메일
  • nickname — varchar(50) — NOT NULL — 회원닉네임
  • password — varchar(100) — NOT NULL — 회원비밀번호
  • provider — varchar(10) — NOT NULL — 도메인발급형태
  • createdAt — datetime — NOT NULL — 생성일시
  • updatedAt — datetime — NOT NULL — 수정일시
  • deletedAt — datetime — 삭제일시