CMARKET_TEST

Tables (14)

auto_login_tb (Untitled13)

  • Key — Primary key — NOT NULL

block_tb (Untitled5)

  • blocker (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
  • blocked (Key22) — number — Foreign key → profile_tb.user_sq — NOT NULL

board_content_tb (Untitled2)

  • board_content_sq (Key) — number — Primary key — NOT NULL
  • board_sq (Key2) — number — Foreign key → board_tb.board_sq — NOT NULL
  • board_content (Field) — varchar2(4000) — NOT NULL

board_tb (Untitled7)

  • board_sq (Key) — number — Primary key — NOT NULL
  • board_category (Key2) — varchar2(100) — Foreign key → category_tb.cate_sq — NOT NULL
  • board_writer (Key3) — varchar2(100) — Foreign key → profile_tb.profile_sq — NOT NULL
  • board_title (Field) — varchar2(255) — NOT NULL
  • price (Field3) — number — NOT NULL
  • board_img (Field4) — varchar2(255) — NOT NULL
  • board_dips_cnt (Field9) — number — NOT NULL
  • board_chat_cnt (Field10) — number — NOT NULL
  • board_views_cnt (Field12) — number — NOT NULL
  • board_date (Field11) — date — NOT NULL
  • board_update_date (Field2) — TIMESTAMP — NOT NULL
  • board_address (Field5) — VARCHAR2(100) — NOT NULL
  • nego (Field6) — VARCHAR2(2) — NOT NULL
  • board_state (Field7) — VARCHAR2(2) — NOT NULL
  • board_sample4_jibunAddress (Field8) — VARCHAR2(100) — NOT NULL
  • profile_sq (Key4) — number — Foreign key → profile_tb.profile_sq — NOT NULL

category_tb (Untitled6)

  • cate_sq (Key) — number — Primary key — NOT NULL
  • cate_name (Field) — varchar2(100) — NOT NULL

chat_header_tb (Untitled10)

  • id (Key3) — number — Primary key — NOT NULL
  • from_id (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
  • to_id (Key22) — number — Foreign key → profile_tb.user_sq — NOT NULL
  • receiver (Field) — number — NOT NULL
  • title (Field2) — varchar2(127) — NOT NULL
  • status (Field3) — varchar2(20) — NOT NULL
  • date (Field4) — date — NOT NULL

chat_message_tb (Untitled14)

  • id (Key) — number — Primary key — NOT NULL
  • header_id (Key3) — number — Foreign key → chat_header_tb.id — NOT NULL
  • is_from_sender (Field) — varchar2(100) — NOT NULL
  • content (Field2) — varchar2(2000) — NOT NULL
  • read (Field3) — varchar2(20) — NOT NULL
  • date (Field4) — date — NOT NULL

dips_tb (Untitled8)

  • profile_sq (Key3) — number — Foreign key → profile_tb.profile_sq — NOT NULL
  • board_sq (Key) — number — Foreign key → board_tb.board_sq — NOT NULL

file_tb (Untitled12)

  • file_sq (Key) — number — Primary key — NOT NULL
  • board_content_sq (Key2) — number — Foreign key → board_content_tb.board_content_sq — NOT NULL
  • file_name (Field) — varchar2(255) — NOT NULL
  • file_org_name (Field2) — varchar2(255) — NOT NULL
  • file_size (Field3) — number — NOT NULL

follow_tb (Untitled4)

  • follower (Key) — number — Primary key — NOT NULL
  • leader (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL

profile_comment (Untitled3)

  • comment_sq (Key) — number — Primary key — NOT NULL
  • profile_sq (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
  • com_judge (Field2) — VARCHAR(1) — NOT NULL
  • com_writer (Field4) — varchar2(100) — NOT NULL
  • com_writer_sq (Field6) — NUMBER
  • com_img (Field5) — varchar2(255) — NOT NULL
  • com_content (Field3) — varchar2(1000) — NOT NULL
  • com_date (Field) — date — NOT NULL

profile_tb (Untitled11)

  • profile_sq (Key) — number — Primary key — NOT NULL
  • user_sq (Key2) — number — Foreign key → user_tb.user_sq — NOT NULL
  • profile_nickname (Field) — VARCHAR2(100) — NOT NULL
  • profile_gender (Field2) — VARCHAR2(1) — NOT NULL
  • profile_photo (Field3) — VARCHAR2(255) — NOT NULL
  • profile_temperature (Field4) — NUMBER — NOT NULL
  • profile_date (Field5) — DATE — NOT NULL

tag_tb (Untitled9)

  • profile_sq (Key2) — number — Foreign key → profile_tb.profile_sq — NOT NULL
  • tag_name (Field) — varchar2(20) — NOT NULL

user_tb (Untitled)

  • user_sq (Key) — number — Primary key — NOT NULL
  • user_id (Field) — varchar2(100) — NOT NULL
  • user_pwd (Field2) — varchar2(255) — NOT NULL
  • user_name (Field3) — varchar2(255) — NOT NULL
  • email (Field6) — varchar2(255) — NOT NULL
  • phone (Field7) — varchar2(255) — NOT NULL
  • address (Field4) — VARCHAR2(255) — NOT NULL
  • sample4_postcode (Field5) — VARCHAR(25) — NOT NULL
  • sample4_roadAddress (Field8) — VARCHAR(100) — NOT NULL
  • sample4_jibunAddress (Field9) — VARCHAR(100) — NOT NULL
  • sample4_detailAddress (Field10) — VARCHAR(100) — NOT NULL
  • user_status (Field11) — VARCHAR2(1) — NOT NULL